? for Excel brainiacs, please.

[gillenr]

How can you add cells together that contain hours & minutes in the format HR:MIN if the total exceeds 48 hours?
Thanks

[Dave Schwartz]

Gillen,

Sorry, not a "Brainiac" but I can make it work...




Create a cell that turns it into decimal hours.

1. Find out the value of 1 hour .

A1= 7:00:00
B1= 6:00:00
C1= A1-B1

Change the format of C1 to an integer. This stores the "value of an hour."


Date begins in (say) A3.

A column= a value in hours such as 0:5:48:00.
B column= the A column divided by C1.

Example:

A5= 5:48:00
B5= A5 / C1 (formatted as an integer)

A6= 22:37:00
B6= A6 / C1 (formatted as an integer)


Hope this helps.


Dave SChwartz

[gillenr]

I tried what I think you wrote, but it didn't work. If possible, I'll attach what I did.
Thanks.
Wouldn't allow .xls, so I changed ext. to .bmp. But it is .xls.

[Larry Hamilton]

Try this:

select all the cells you want the time to be in. Go to format, Choose Cells, choose numbers tab, choose Custom,

in the white box under the words:"Type:", enter this: [h]:mm

[Dave Schwartz]

Empty spreadsheet.

[Tom]

Originally posted by Dave Schwartz
Empty spreadsheet.

A-ha! :D