New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.


Elapsed time calculation

Formulas, Functions, Formatting, Charts, Data Analysis, etc.
Forum rules
This forum is closed.

All new posts should be made at our new Excel Forum at

Elapsed time calculation

Postby kecocontrols » Tue Dec 13, 2016 9:46 am

I have a hours:minutes columns that I need to subtract from each other to get elapsed time in.

Example: a6 – a5 =?

on a basic subtraction I get a value error
a1 = 11549:06
a2 = 11573:06
a3 = 11597:06
a4 = 11621:06
a5 = 11645:06
a6 = 11669:06

It seems that Excel 2007 has trouble with HHHHH:MM format. I would be willing to work with a column were the minutes are stripped off. Then it becomes just a simple subtraction.
  • 0

Posts: 1
Joined: Dec 13, 2016
Reputation: 0
Excel Version: 2007

Re: Elapsed time calculation

Postby gebobs » Tue Dec 20, 2016 9:08 am

I like it when folks answer their own questions. Good job.
  • 0

Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010

Return to General Excel Questions

Who is online

Users browsing this forum: Baidu [Spider], Google [Bot] and 6 guests