time entry's

[jonboy0766]

Hi

Can some one advise how I make the numbers 1, 2 and 8 appear in a time format of HH:MM in the formula below

i.e 01:00, 02:00, 08:00

=IF(A2="P1 Fault",1,IF(A2="P2 Fault",2,8))

Cheers

Jon

[martindwilson]

divide by 24 format cell as hh:mm
=IF(A2="P1 Fault",1,IF(A2="P2 Fault",2,8))/24