Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I have a total of 1346:16:00 hours formatted [h]:mm:ss. When I try to divide
this into number of peices picked 13384. I get 238.60 but when I have entered on the calculator I get 9.94. Can someone tell me what the proper format is to return the proper result? Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Displaying calculated times - half-hours are not calculating... | Excel Worksheet Functions | |||
Problem with adding calculated times | Excel Discussion (Misc queries) | |||
How do I add times calculated using =TEXT(D40-C40+(F40-E40),"h:mm" | Excel Worksheet Functions | |||
Comparing Calculated Times | Excel Worksheet Functions | |||
reducing the number of times an IF statement needs to be calculated in embedded IF statements | Excel Discussion (Misc queries) |