Articles

excell formula time sheet conversion

January 26, 2011 at 07:15:33
Specs: Windows XP

Time in = military; time out = military; lunch = minutes [ie 30 not .5]
I need the formula to calculate actual hours worked to decimal time.
Example
Time in: 08:00
Time out: 16:45
Lunch: 30
Actual Hours: 8.25

See More: excell formula time sheet conversion

Report •


#1
January 26, 2011 at 11:58:15

There are a great many freeware scheduling/timesheet templates available
out on the web, if you haven't already, I would advise you to look around,
see what you like and use it.

Here is the MS site:
http://office.microsoft.com/en-us/t...

But in case you really want to do it, here is one way:

       A          B
1) Time In       7:20
2) Time Out     12:00
3) Time In      13:00
4) Time Out     15:25
5)
6) Lunch         1:00
7) Total Hours   7:05

Format cells in Column B as Custom, [H]:MM
the square bracket is required.

In Cell B6 enter the formula: =SUM(B3-B2)
In Cell B7 enter the formula: =SUM(B4-B3)+(B2-B1)

MIKE

http://www.skeptic.com/


Report •

#2
January 26, 2011 at 12:10:37

OOPS, forgot you wanted the total time in decimal format.

Change the format in Cell B7 to: Number
Change the formula in Cell B7 to: =(SUM(B4-B3)+(B2-B1))*24

That should give you the total time in decimal format.

MIKE

http://www.skeptic.com/


Report •

Related Solutions


Ask Question