|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 9th, 2009, 10:31 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
+24 hours time format
Hi.
What's the easiest way to format a cell showing +24 hours? I'd like to calculate with times bigger that 24 hours (e.g. 122:22:33). How can I do this? Thanks, -- Georges Heinesch 
|
|
#2
February 9th, 2009, 10:44 AM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
+24 hours time format
Georges Heinesch;220497 Wrote: Hi. What's the easiest way to format a cell showing +24 hours? I'd like to calculate with times bigger that 24 hours (e.g. 122:22:33). How can I do this? Thanks, -- Georges Heinesch Try [h]:mm:ss as format -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=60693
|
|
#3
February 9th, 2009, 12:48 PM
posted to microsoft.public.excel.newusers
|
|||
|
|||
|
+24 hours time format
Pecoflyer wrote:
Try [h]:mm:ss as format Easy  , but you need to know it.Thanks a lot! -- Georges Heinesch
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
