Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i needed to calculate some hours from work and now that i am done it won't
let me turn my answer into a number. How do i do it? total time 3:45 i want it to be 3.45 because i need to divide it by 2 and then multiply it by 5 but when i put the formula it does not give me the right answer? can someone help me? To understand what i am saying is that every 2 hours = 5 points but since I only worked 3.45 hours then how can i get a formula to get an answer. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Capturing average turn around time with constraints | Excel Worksheet Functions | |||
How to do average turn around time with criteria | Excel Discussion (Misc queries) | |||
turn around time | Excel Worksheet Functions | |||
Turn around Time | Excel Worksheet Functions | |||
Calculating TAT (Turn Around Time) | Excel Worksheet Functions |