employee schedule with hours
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) |
employee schedule with hours
I would advise that you use two columns - one for start time and
another one for finish time. Then you can get the hours in a third column by subtracting start time from finish time and multiplying by 24. Hope this helps. Pete On Aug 1, 1:56 pm, Dawn P <Dawn 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) |
employee schedule with hours
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) |
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) |
All times are GMT +1. The time now is 10:56 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com