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

  • Thread starter Thread starter sashaikh
  • Start date Start date
S

sashaikh

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
 
One way:

C1: =B1-A1

Format C1 with Format/Cells/Number/Custom [h]:mm
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert two dates in to HH:MM:SS 1
How to enter start and end date/time in excel based on some specific value. 7
Calculating tiome between 17 PM and 6 AM 23
Excel - 24 time into absolute numbers or time *Tough One* 1
Converting hh:mm:ss.nnn to mm.000 4
how to date 4
Decimal numbers to time format. 5
SUMPRODUCT Date Ranges 5

Back
Top