View Single Post
  #1   Report Post  
DejaVu
 
Posts: n/a
Default Adding dates and times


I need to figure out how to add dates and times in excel! I've been
playing around with it but can't seem to get it the way I need it.
Say, for example, I have two dates and times:
1.) 10/07/05 13:30
2.) 10/10/05 15:45
I want it to somehow return _74_hours_and_15_minutes_ in the form
*74:15*

Is this possible!?

TIA,
DejaVu


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=479280