| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Converting Millitary Time to Hours worked and OT hours
What I'm trying to do is. Take 700 start time to an end time of 1700 then I
need it to convert it to hours worked then the next cell show hours no more then 8 in the next cell any thing over the 8 hours. Start time would be one cell, End time is one cell, Total Hours is one sell, Hours no more them 8 is one cell, overtime hours is one cell. Then I have to Multiply the 8 hours in the next cell and then the ot hour in the next cell. Any help would be fine. Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating Bi-Weekly Time Sheet to Calculate Hours Worked | Excel Discussion (Misc queries) | |||
| Calculate Total hours worked during workdays within given shift time. | Excel Discussion (Misc queries) | |||
| wages - multiply hours and minutes by number of hours worked | Excel Discussion (Misc queries) | |||
| Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
| time format multiplied by hours worked ? | Excel Worksheet Functions | |||
Threaded Mode
