Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm trying to display elapsed time separately so that I can see hours in one
cell and minutes in another cell. I've been using the following to display hours: =TEXT(MOD(C5-C4,1),"hh"), but when I use the same function and change the "hh" to "mm", I can't get it to display the minutes correctly. I'm assuming that it's because of the 2nd argument of the MOD function, it always displays 01 whatever I type in. Would someone please tell this simple individual what I'm doing wrong. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating elapsed time | Excel Discussion (Misc queries) | |||
Need Elapsed Time Help | Excel Worksheet Functions | |||
Do when a time and date has elapsed | Excel Discussion (Misc queries) | |||
elapsed time | Excel Worksheet Functions | |||
Elapsed time | Excel Discussion (Misc queries) |