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" <(E-Mail Removed)> wrote in message
news:8c2a705a-9ad4-42de-871f-(E-Mail Removed)...
> 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