Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dividing Time
I have one cell with a sum of time reduced by allowing staff to leave early on days where we're slow. I'm using the custom format [h]:mm. All I want to do is divide that number by 37.5 hours and I'm having a fair bit of trouble. Any pointers on what formula and/or syntax I should be using? I've tried simply doing =A1/37.5 but the result I'm getting back is not correct. I'm looking to have the result represented as a number w/ 2 decimal places to indicate the FTE (Full Time Equivalent = 37.5 hours per week) we've saved. -- guilbj2 ------------------------------------------------------------------------ guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043 View this thread: http://www.excelforum.com/showthread...hreadid=544655 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hot key for time? | New Users to Excel | |||
Hot key for time? | Excel Worksheet Functions | |||
Hot key for time? | Excel Discussion (Misc queries) | |||
Dividing a time span into shifts - overlapping days | Excel Worksheet Functions | |||
time differences in a column | Excel Worksheet Functions |