tracking hours

**ClearConcept** · 08-29-2012, 06:04 PM

I just don't see what's wrong with my spreadsheet. It's a simple 6 column spreadsheet: day, date, arrive, depart, time, and running total. Can I email it so someone can tell me what I'm missing (other than a brain)?

**rizmomin** · 08-29-2012, 06:12 PM

Hello:

Please post your sheet as attachment..

Thanks

Riz

**ClearConcept** · 08-29-2012, 06:36 PM

Didn't know I could - just found it - it's attached

**Kevin UK** · 08-30-2012, 05:35 AM

Hi ClearConcept

Format the cells: [h]:mm

**ClearConcept** · 08-30-2012, 09:40 AM

Thank you! I didn't have [h]:mm on the custom (type) list. Only h:mm was listed. I've added it. Out of curiosity, why do you suppose h:mm worked for the 5 cells before it in the same column? Any idea what h:mm actually means as compared to [h]:mm ? Not that it matters that much - it works - but ignorance is not bliss for me

**Kevin UK** · 08-30-2012, 09:51 AM

They were less than 24 hours

**MarvinP** · 08-30-2012, 09:55 AM

I too wonder why and find:
http://support.microsoft.com/kb/266691
http://office.microsoft.com/en-gb/ex...005199500.aspx

and finally using a search of "Excel Format Elapsed Time"
http://office.microsoft.com/en-us/ex...001216503.aspx
where it explains it this way...

Displays elapsed time in hours. If you are working with a formula that returns a time in which the number of hours exceeds 24, use a number format that resembles [h]:mm:ss.