Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am setting up a spread sheet to use as a time sheet for my son. I have use
used the time format in to cells. Next I used the [h]:mm:ss to calculate the elapsed time. Ok, that seemed to work just fine. Now I would like to multiply the elasped time returned by a dollar value in another cell. It appears that the value returned by the [h]:mm:ss operator does not return a real number that can be used to multiply by. I'm sure that there is some conversion that I just missing. I would like to know how to fix this problem. Dean |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Displaying date as a real number | Excel Discussion (Misc queries) | |||
Convert real time to a % in Excel | Excel Discussion (Misc queries) | |||
real number | Excel Discussion (Misc queries) | |||
Convert real number to an h:mm:ss display | Excel Worksheet Functions | |||
How do you convert numbers to real text | Excel Discussion (Misc queries) |