Thanks Dave and Steve. I was playing around with INT, but not MOD, so
couldn't get it to work. Your solution works great.

"berniean" wrote:

Hi,
How do I take a number, e.g., 170.5, and covert it to a weeks, days, hours,
and minutes, based on an 8 hour day and a 40 day week? Simple math just gives
me more decimals. I don't want 4.2625 weeks, I want 4 weeks, 1 day, 2 hours,
30 minutes. I want to be able to do this for any number using a formula or
group of formulas.

All help is greatly appreciated.

Thanks,
Bernie