MetaChat REGISTER   ||   LOGIN   ||   IMAGES ARE OFF   ||   RECENT COMMENTS




artphoto by splunge
artphoto by TheophileEscargot
artphoto by Kronos_to_Earth
artphoto by ethylene

Home

About

Search

Archives

Mecha Wiki

Metachat Eye

Emcee

IRC Channels

IRC FAQ


 RSS


Comment Feed:

RSS

29 June 2011

Any Excel gurus here? My AskMe scrolled off the page before I got a complete answer :-(
post by: dg at: 17:21 | 4 comments
Ooo! I know this one!!

This is the result of a setting in format cells. Highlight the cells, go to Format Cells, and then in the Custom section put brackets [] around the h that symbolizes hours. Your current format should be showing in the Custom box. That will clue Excel in that you want it to keep counting past 24 hours.
posted by jeoc 29 June | 18:00
Awesome! There is a custom format already defined for this in the version of Excel I use (2003) - [h]:mm:ss, so it was a simple couple of clicks to solve.

It's just as easy in Google Docs - click 'Format', then 'Number', then choose 'hours'

Thanks a lot!

I'll add this to the AskMe to complete the info - do you mind if I quote your user name?
posted by dg 29 June | 18:06
Sure - I left a comment there as well, though.
posted by jeoc 29 June | 18:28
Saw that - thanks again.
posted by dg 29 June | 19:04
Drug! (SLYT) || Pranking the significant other

HOME  ||   REGISTER  ||   LOGIN