Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a schedule that works really well to calculate how many total hours
per employee, but when I want to add a column that multiplies the total hours by an rate per hour, the result isn't right--it comes out in the form of time. If I have a cell that results in 32:00:00 total hours and have that multiplied by say 7 dollars per hour the answer comes out as 224:00:00. I need to use the result in other labor cost calculations, but it wont' work as a time. Is there a way to make that into a number (e.g. 224 )? I need to be able to divied the 224:00:00 result by a number equal to total revenue and derive a percentage. Any ideas? Thanks people. Rudy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help - Information with time and date | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) |