excel problem

%3CLINGO-SUB%20id%3D%22lingo-sub-1423818%22%20slang%3D%22en-US%22%3Eexcel%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423818%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20how%20do%20I%20express%20the%20total%20time%20of%2027%3A45%3A00%20(total%20hrs%20worked%20by%20person%20in%209%20hr%20day)%20as%20total%20days%3F%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1423818%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1423910%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1423910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F682325%22%20target%3D%22_blank%22%3E%40Neels1508%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20total%20time%20as%20time%20is%20in%20A1%2C%20the%20same%20in%20days%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DA1%2F9*24%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eand%20apply%20Number%20format%20to%20the%20result%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted

@Neels1508 

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

=A1/9*24

and apply Number format to the result