asked on

EXCEl Time Difference

Hi
I have a excel spread sheet in which I want to calculate time difference between two time
Time 1: 1:45 PM
Time 2 : 1:55 PM

Difference = 0:10

Thanks

SOLUTION

Saurabh Singh Teotia

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

surah79

ASKER

i did that its not working for all its giving some error #Value!

DrewK

Make sure you have cell format set to "Date"

Wilder1626

Hi

is this what you are looking for?

Please look at attachment.

=(A2-A1)*1440

Open in new window

Excel-time-difference.xlsx

SOLUTION

Wilder1626

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Saurabh Singh Teotia

surah79,

Can you post your file so that i can look into it what's wrong...

Saurabh...

SOLUTION

Frank Helk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Wilder1626

If you just use this: =TEXT(B1-A1,"h:mm"), you will get exactly what I think you are looking for.

SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

Rob Henson

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

surah79

ASKER

Thanks a lot everyone.