After using the formula A1/24/60 (convert minutes to h:mm), when it exceeds
120 hours, it resets. How can I fix this?
Toppers - 16 Jun 2006 23:59 GMT
Format cell as [hh]:mm
> After using the formula A1/24/60 (convert minutes to h:mm), when it exceeds
> 120 hours, it resets. How can I fix this?
Bernard Liengme - 16 Jun 2006 23:59 GMT
Format with [h]:mm

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
> After using the formula A1/24/60 (convert minutes to h:mm), when it
> exceeds
> 120 hours, it resets. How can I fix this?