what formula for keeping balance of excess hours/minutes?
 

I am trying to create a timesheet in Excel whereby I enter a start time and a
finish time less breaks. This I can format, but I would then like to find a
formula to calculate if the hours worked are over or under a standard time
eg, 06:00 - 18:00 less 0:30 = 11.5hrs. Standard time per day is 8hrs, so
this would give an excess of 3.5hrs.
I would like to keep a running balance of each person each day as
accumulated time to 23.59hr and from 24hr have that converted into days ie 1
day time off owing or 1 day work owing.

what formula for keeping balance of excess hours/minutes?
 

=MAX(0,total_hours_for_day,TIME(8,0,0))

Then just sum these and multiply by 24

=SUM(totals_range)*24

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Michele01" wrote in message
...
I am trying to create a timesheet in Excel whereby I enter a start time and
a
finish time less breaks. This I can format, but I would then like to find
a
formula to calculate if the hours worked are over or under a standard time
eg, 06:00 - 18:00 less 0:30 = 11.5hrs. Standard time per day is 8hrs, so
this would give an excess of 3.5hrs.
I would like to keep a running balance of each person each day as
accumulated time to 23.59hr and from 24hr have that converted into days ie
1
day time off owing or 1 day work owing.