Total Hour Difference Between 2 Dates & Times

Nobi · May 22nd 2008

Hello,

I have two rows of data (A & D) which I would like to determine the amout of time spent for each issue. The value in both column appears as DD/MMM/YY HH:MM:SS. I am looking for a formula to obtain the below result.

Desired Output:
A1 = 05/21/08 10:00:00
D1 = 05/22/08 13:01:00
E1 = 27:01 hours

Thank you for your time!!

VBA Noob · May 22nd 2008

Re: Formula To Subtract A Time Value

Try =D1-A1

format the cell as [h]:mm

VBA Noob

Dave Hawley · May 23rd 2008

If you wish to continue using this free service.

Please be considerate of others who use the forum for searching. Your current Thread Title (which I will change) is non-reflective of your immediate problem.

In future, please take 1 minute of your time to read the text on the New Thread page.

[fa]*[/fa]

REMEMBER: Your thread title should NEVER be what you THINK is your answer. 9 times out 10 it will wrong and prevent someone from finding a solution to a simliar issue.

Total Hour Difference Between 2 Dates & Times

Participate now!

Share