employee schedule with hours
Pete's response will give "hours worked" as decimal hours i.e 7 hours 30
minutes = 7.5, whilst my response will be time in hours/minutes. Pete's is
generally the "better" solution: note the "hours worked" cell should
formatted as General (or Number) in Pete's solution.
"Toppers" wrote:
If A1 =09:00 & B1=16:00 then hours worked in C1:
=B1-A1
I recommend you put Start & End times in different columns
"Dawn P" wrote:
I am trying to create schedule for employees by tracking their hours in one
column (9am-4pm) and to find a formula that will calculate the total number
of hours in the next column. (9am-4pm) (7 hours)
|