Display Elapsed Time
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
|