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

"Bob Phillips" wrote:

Subtract the former from the later and format the result as date and time.

--
HTH

Bob Phillips

"Jeff" wrote in message
...
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.