P Paul Apr 8, 2008 #1 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.
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 Apr 8, 2008 #2 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
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
