May 28 2020 06:52 AM
Hi, how do I express the total time of 27:45:00 (total hrs worked by person in 9 hr day) as total days??
May 28 2020 07:33 AM
If total time as time is in A1, the same in days
=A1/9*24
and apply Number format to the result