SOLVED

Dividing of a number thru time

%3CLINGO-SUB%20id%3D%22lingo-sub-1626316%22%20slang%3D%22en-US%22%3EDividing%20of%20a%20number%20thru%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1626316%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20i%20have%20a%20number%20in%20exel%20lets%20say%201600%20in%20A1%20and%20want%20to%20divide%20it%20by%20a%20time%2010%3A00%3A00%20In%20A2%20what%20do%20i%20need%20to%20do%20or%20type%3F%3C%2FP%3E%3CP%3E1600%20divided%20by%2010%20hours%20%3D%20160%20is%20the%20answer%20i%20want%20from%20my%20exel%20sheet%20in%20A3%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1626316%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1626345%22%20slang%3D%22en-US%22%3ERe%3A%20Dividing%20of%20a%20number%20thru%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1626345%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F778718%22%20target%3D%22_blank%22%3E%40Dankoi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20Excel%201%20day%20is%20equal%20to%201%2C%20thus%201%20hour%20is%201%2F24%2C%20thus%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DA1%2FA2%2F24%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3Eand%20apply%20General%20format%20to%20the%20result.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

If i have a number in exel lets say 1600 in A1 and want to divide it by a time 10:00:00 In A2 what do i need to do or type?

1600 divided by 10 hours = 160 is the answer i want from my exel sheet in A3

1 Reply
Highlighted
Best Response confirmed by Dankoi (Occasional Visitor)
Solution

@Dankoi 

In Excel 1 day is equal to 1, thus 1 hour is 1/24, thus

=A1/A2/24

and apply General format to the result.