Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA | Excel Worksheet Functions | |||
Can I use Excel to add hours and minutes like keeping a dive log? | Excel Discussion (Misc queries) | |||
add hours & minutes to other hours & minutes to receive total hou. | Excel Worksheet Functions | |||
Formula for minutes to days:hours:minutes | Excel Discussion (Misc queries) | |||
ADD TIME IN EXCESS OF 24 HOURS | Excel Worksheet Functions |