I'm not sure if this will meet your needs, but a formula of =A1/8 and a
Custom Format as such:

#\d # \h /8

will return your number of 4782 as "*597d 6 h /8*" and will be
available for subsequent math actions.

note: the /8 will be visible but simply indicates an 8 hour day and
does not hamper calculations on the value contained within the cell.

also note that even days (eg 4784 will return simply "598" and 8
returns "1") and less than one day (e.g. 5) returns "5 h /8"

Does this work for you?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=384618