Calculating Time

[chegra26]

I have a a database that calculates time
My fields are
BeginTime
EndTime
TotalTime

BeginTime1
EndTime1
TotalTime1

BeginTime2
EndTime2
TotalTime2

TotalTimeCal - Sum of Total Time + TotalTime1 + TotalTime2
This calculation shows the sum of the three totals in hours and minutes, for example 7:33 (7 hours 33 minutes)
How do I get this total to display 7.5?

 

[mole999]

format as decimal ?

 

[chegra26]

I need the field to show as 7.33 but I also need a separate field that shows it as 7.5.

 

[chegra26]

I have the following formula
-Int(-(TimeValue([TotalTimeTotal])*24)/0.25)*0.25
However, it rounds 5.33 up to 5.75 instead of 5.5

 

[mole999]

apples and pears you can't just switch decimal with time and expect it to behave nicely 5.33 won't round to 5.75, whereas 5:33 might. If you have a natural time in one location, just point your new location to it and change the format to decimal, then you can display both

 

[xenou]

I came up with round(cdbl(timevalue("07:33"))*24*4)/(24*4)*24
the 24*4 because that's the number of 15 minute intervals in a day, and the last 24 to get it back into hours.
This appears to be accurate to within about a minute (i.e., when we are talking about times right in the middle such as 7:37.5). Not sure if I like this yet!