calculate difffernce in time in attendane eg 0830 - 1750
 

How do I calculate time difference in hours in my attendance records, eg 0850
to 1950

calculate difffernce in time in attendane eg 0830 - 1750
 

=(end_time-start_time)*24

and format as general

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Fabricare" wrote in message
...
How do I calculate time difference in hours in my attendance records, eg
0850
to 1950