24 Hour Clock Calculations

[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

 

[Roger Govier]

Hi John

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

--

Regards
Roger Govier

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

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

The message was checked by ESET Smart Security.

http://www.eset.com