How to convert two dates in to HH:MM:SS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sashaikh - 21 Oct 2004 15:14 GMT

Hi,

I am trying to calculates the two dates cells diffrence int
hour:minutes:seconds. could some help me in finding a solution i
Excel sheet.

eg. Cell A1 = Jan-01-2004 00:00 Cell B1 = Jan-02-2004 23:30

Cell C1 = 47:30 looking for a result like 47 hours 3
min.

thanks

sa

Reply to this Message

JE McGimpsey - 21 Oct 2004 15:26 GMT

One way:

C1: =B1-A1

Format C1 with Format/Cells/Number/Custom [h]:mm

> Hi,
>
[quoted text clipped - 10 lines]
>
> sas

Reply to this Message