adding up hours as numbers doesnt match hours as time format

DBenz · #10 11-04-2018, 12:26 PM

Hi,
Joeu2004

Quote:

That's because some of the "times" in C2:C39 exceed 24 hours.

I see only 8 hrs as most

Quote:

But really, I suspect the data in C2:C39 is not entirely correct.

For example, C2 8 days plus 8 hours (8:00:00).

I don’t understand, I click C2 and its not saying B2+ 08:00:00

B

Quote:

ut B2 is simply 8 (hours?). So I suspect the 8 days is incorrect.

I manually typed the hh:mm:ss into C to represent hrs for the hours in B
B2 is 8 hrs, you say 8 days.

You lost me I’m afraid.

Quote:

Similarly with C3. But C4 is correctly just 1 hour (1:00:00), and B4 is 1.

So I suspect the root cause of the problem is an inconsistency in converting column B (decimal hours) into column C (Excel time).

Marcia, I see I have a column sorting out the 00:15:00 thanks.

so edit that out of my response

Dbenz

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding Hours in MS Project with Picture	Hochbau	Project	6	02-17-2017 09:45 AM
Calculate Time in Hours and Percent	pabyford	Excel	6	12-13-2016 12:29 PM
Time Function for Tracking Hours	Newto365	OneNote	0	07-11-2016 09:47 AM
8 in 24 hours time formula	v1rt8v2	Excel	7	01-12-2016 06:55 PM
Adding of times total to be in hours	jen0dorf	Excel	4	06-20-2014 11:53 PM