Is there a formula for calculating the amount of hours worked weekly?
Work hours
-
-
-
Please expand....
The short answer is YES
The slightly longer answer would be
Sum of (Days x Hours)
The actual formula will depend on the nature of how (& in what format) you are recording your hours
Welcome to Ozgrid
-
What actually need is a formula that would allow me enter the start time and end time per day and total each day's work hour for the week.
-
Assuming your times are input correctly (i.e. hh:mm)
Just subtract leaving time from starting time to get daily total
To sum the week's hours, a simple SUM will do, however (and this is important) your cell format for the SUM should be [h]:mm - otherwise the SUM will not work correctly
See Dave's tutorial here
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!