How to compute duration in excel

J

Jeff

Hi may I know why we could compute a duration in # of Day, Hours and Minutes.
For example, column 1 is Date 2005/09/22 and Column 2 is Time 10:20:15.
Assuming now is 2005/09/23 and Time 06:14:30. How do I make use of excel
function to get value 0 Days 19 Hrs 54 mins in column 3 ?
Thanks.
 
M

Myrna Larson

Hi, Bob:

Just a caveat: I assume you mean a format like d hh:mm. This won't work if the
time span is greater than 31 days: in the custom format you can't specify [d]
for the days, so 31 would be followed by 1 rather than 32.

Myrna Larson
 
J

Jeff

Bob,

What if there is no current date/time column in excel. Is there a specially
formula such as '%DATE-A1' tabulate in column 3 ?

Rgds..Jeff
 
D

Dave Peterson

Excel has =today() for today's date and =now() for the current date/time.

So you could use:
=today()-a1
(formatted as general)

Remember that those functions get updated--they're not static.
 
J

Jeff

Thanks Dave. It's helpful.

Dave Peterson said:
Excel has =today() for today's date and =now() for the current date/time.

So you could use:
=today()-a1
(formatted as general)

Remember that those functions get updated--they're not static.
Click to expand...
 
Top