excel problem

Copper Contributor

Hi, how do I express the total time of 27:45:00 (total hrs worked by person in 9 hr day) as total days??

1 Reply

@Neels1508 

If total time as time is in A1, the same in days

=A1/9*24

and apply Number format to the result