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