| Home |
| Search |
| Today's Posts |
|
#1
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding time in 24 hour format to produce hours in decimal format | Excel Worksheet Functions | |||
| using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours | Excel Worksheet Functions | |||
| HOW TO CONVERT TIME FORMAT IN HOURS TO MINUTES | Excel Worksheet Functions | |||
| Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
| time format multiplied by hours worked ? | Excel Worksheet Functions | |||
Linear Mode
