Computing Elapsed Time (hours & minutes in one cell)

Posted by Tim on December 13, 2001 7:31 AM

I am trying to put together a spread sheet that tracks current elapsed time over the coarse of days. A would also like minutes to show up in the resulting cell as well.

example: startDT= 12/10/2001 7:00
currentDT= now()

I am looking for an end result in one cell as number of days and hours such as " 3days 10hours"

Thanks for any help!

Posted by IML on December 13, 2001 9:22 AM

You could use the formula
=NOW()-37235.29167
or if the date time will change often, you could use
=NOW()-(DATEVALUE("12/10/2001")+TIMEVALUE("7:00 am"))

apply the custom format
d "days" h "hours" m "minutes"

good luck

Posted by Dan on December 13, 2001 9:32 AM

Or if the start date is in cell A1, just use =Now()A1 and format as IML pointed out.

Posted by Dan on December 13, 2001 9:33 AM

Made a typo. Should be

=Now()-A1

Posted by Tim on December 13, 2001 12:48 PM

OUTSTANDING! Thanks guys. Your pointers worked beautifully.

Merry Christmas!