Calculating Hours

P

Paul

I have a data base to record staff leave ie 7:24 (time & minutes). How
can I calculate the total hours from 5 fields contains h:mm.
 
J

Jerry Whittle

Pardon me if this reply shows up more than once. Something strange happened
when I tried to post it.

TheHours: CDbl([Field1] + [Field2] + [Field3] + [Field4] + [Field5]) *24

The above will give you the hours, but the decimal part won't be minutes. It
will be the decimal part of an hour. For example:

1.5 = 1:30
7.4 = 7:24
 
Top