I have a calculated field in a query that returns the difference between two

times with a time format of h:nn; for example, one hour and thirty minutes is

displayed as 1:30. I need the value of 1:30 displayed in minutes, so I need

to see the value as 90 minutes. If I use the "n" format for minutes it only

returns the minutes without the hours so in the case of 1:30 it only returns

30 and not 90. How do I format or calculate the field to return the value in

minutes so that 1:30=90, 2:45=165, 0:33=33?

Are you using n in a Format or in DateDiff?

Your DateDiff function can calculate the difference in minutes:

? datediff("n", #01:00#, #02:30#)

90

Tom Lake

I was using format. I changed it to DateDiff as per your example and it

returned the minutes just like I was looking for!

Thank you,

Scott

returned the minutes just like I was looking for!

Thank you,

Scott

1. CONVERT Hours:Minutes to Minutes

2. Convert hours:minutes into days, hours, minutes

3. Convert day, minutes hours into hours:minutes

4. convert time from 60 minute hour to 100 minute hour

5. convert 100 minute hour to a 60 minute hour

6. Convert hours and minutes into minutes

7. convert minutes into hours:minutes

8. How do I convert 184 minutes into 3:04 (3 hours:4 minutes) in EXCE

9. Converting minutes to hours and minutes

10. Converting total minutes to hours with minutes

11. I have 3053 minutes and I want to convert to hours and minutes

12. converting days, hours and minutes to minutes

13. Converting hours & minutes to whole minutes

14. Convert minutes into hours and minutes

15. Convert 13 hours a 10 minutes to total minutes

3 post • Page:**1** of **1**