Thread: Time Spent
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
joel[_868_] joel[_868_] is offline
external usenet poster
 
Posts: 1
Default Time Spent


All you need to do is use a formula
=B4 - B3

then format the cell with the formula in any Time or Date format. I
usually recommend using custom format [h]:mm:ss because time formats
when over 24 hours truncates the hours to be less than 24. The custom
format showsx the hours greater than 24.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=194050

http://www.thecodecage.com/forumz