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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Calculation 9
how to calculate total time in query 2
Sum Hours over 24 hours in Access Report 0
Converting Work Days to Hours 5
Create formula for "Total Hours" field 1
Totaling Times 2
calculation of fields 2
Time calculations for Scheduled vs Actual Employee Time and Wages 4

Top