Home |
Search |
Today's Posts |
#1
|
|||
|
|||
CALCULATE HOURS WORKED
I am fairly new to Excel, but I need the formula to calculate hours worked,
to include 30-60 min off for lunch. Formula must include hours and minutes worked. |
#2
|
|||
|
|||
You can do math on dates and times exactly as you would with numbers.
a b c d 09:00 12:00 13:00 17:00 =(b1-a1)+(d1-c1) "Calculation of hours worked." wrote: I am fairly new to Excel, but I need the formula to calculate hours worked, to include 30-60 min off for lunch. Formula must include hours and minutes worked. |
#3
|
|||
|
|||
....oh then you can format the answer to hh:mm
"Calculation of hours worked." wrote: I am fairly new to Excel, but I need the formula to calculate hours worked, to include 30-60 min off for lunch. Formula must include hours and minutes worked. |
#4
|
|||
|
|||
To add to what Jimbola wrote-
If you are totaling up time for a week or longer, you should use a Number Format such as: [h]:mm This will allow the hours total to go passed 2. tj "Calculation of hours worked." wrote: I am fairly new to Excel, but I need the formula to calculate hours worked, to include 30-60 min off for lunch. Formula must include hours and minutes worked. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can i tell excel to cumalative the hours so 17:00 + 10:00 = 2. | Excel Discussion (Misc queries) | |||
Employee schedule: I want it to calculate time entered such as 11. | Excel Discussion (Misc queries) | |||
excel template that can add up hours and cost per hour | Excel Discussion (Misc queries) | |||
Problems calculating total hours | Excel Discussion (Misc queries) | |||
calculate percent increase | Excel Discussion (Misc queries) |