View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nigel Nigel is offline
external usenet poster
 
Posts: 98
Default 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