LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculating elapsed time tele2002 Excel Discussion (Misc queries) 2 December 22nd 05 05:47 PM
Need Elapsed Time Help Jwy Excel Worksheet Functions 2 September 29th 05 03:54 AM
Do when a time and date has elapsed Michael Excel Discussion (Misc queries) 3 April 24th 05 10:46 PM
elapsed time Sweetpea60 Excel Worksheet Functions 6 March 2nd 05 04:41 PM
Elapsed time relux Excel Discussion (Misc queries) 1 February 16th 05 09:47 PM


All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"