24 Hour Clock Calculations

  • Thread starter Thread starter JohnA
  • Start date Start date
J

JohnA

I need to extract payroll data from a spreadsheet where start and stop
time is input in 24 hour clock time and I need total decimal hours to
come out of :

Clock In
Clock Out (for Lunch)
Clock In
Clock Out (end of day)

0700
1130
1200
1700

What kind of formula do I need? Thank you for your help.

JohnA
 
Hi John

=((A2-A1)+(A4-A3))*24

--

Regards
Roger Govier

JohnA said:
I need to extract payroll data from a spreadsheet where start and stop
time is input in 24 hour clock time and I need total decimal hours to
come out of :

Clock In
Clock Out (for Lunch)
Clock In
Clock Out (end of day)

0700
1130
1200
1700

What kind of formula do I need? Thank you for your help.

JohnA

__________ Information from ESET Smart Security, version of virus
signature database 5418 (20100902) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 5418 (20100902) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Back
Top