New Excel Forum

This forum has been moved to TeachExcel.

Ask all future questions in the new excel forum.

ExcelKey

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 TeachExcel.com.

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

kecocontrols
Rookie
 
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

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


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 1 guest