Customized cell formatting

  • Thread starter Thread starter AH
  • Start date Start date
A

AH

Hi,

Does anybody have any idea how to use cell formatting to show times like
this. One day should be 8 hours long (like normal working time). So any
values below 1/3 should be show like normal hours and minutes, but when this
is exceeded, the first value should indicate working days.

An example shows what I mean:

0.25 => 6:00
0.5 => 1 day 4:00
1.0 => 3 days

and so on.

Thanks in advance,

Asser
 
Thank you for your time Stephen.

I though it too that it wouldn't be possible. I just wanted to be sure. I'll
use your nice formula.

Thanks again,
Asser
 
Back
Top