SOLVED

Converting time into 15 minute billing units

%3CLINGO-SUB%20id%3D%22lingo-sub-2955004%22%20slang%3D%22en-US%22%3EConverting%20time%20into%2015%20minute%20billing%20units%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2955004%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20fighting%20with%20the%20problem%20of%20converting%20time%20(h%3Amm)%20into%2015%20minute%20billing%20units%2C%20while%20always%20rounding%20down%20to%20the%20lowest%20number%20of%20full%20units.%26nbsp%3B%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EI'm%20using%26nbsp%3BMicrosoft%C2%AE%20Excel%C2%AE%20for%20Microsoft%20365%20MSO%20(Version%202110%20Build%2016.0.14527.20234)%2064-bit%20on%20a%20Windows%2010%20PC.%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EFor%20example%2C%20if%20the%20time%20I'm%20dealing%20with%20is%2014%20minutes%2C%20that%20would%20round%20down%20to%20zero%20units.%2016%20minutes%20would%20round%20down%20to%201%20unit.%2029%20minutes%20would%20also%20round%20down%20to%201%20unit.%20In%20the%20attached%20sample%20document%3A%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3E0%3A15%20%3D%201%20unit%3CBR%20%2F%3E1%3A14%20%3D%204%20units%3CBR%20%2F%3E0%3A31%20%3D%202%20units%3CBR%20%2F%3E0%3A45%20%3D%203%20units%3CBR%20%2F%3E%26nbsp%3B%3CBR%20%2F%3EAny%20suggestions%20would%20be%20appreciated.%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2955004%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2955122%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20time%20into%2015%20minute%20billing%20units%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2955122%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1078624%22%20target%3D%22_blank%22%3E%40Tom_M_1969%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20C5%3A%3C%2FP%3E%0A%3CP%3E%3DQUOTIENT(B5%2CTIME(0%2C15%2C0))%3C%2FP%3E%0A%3CP%3EFill%20down.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2955195%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20time%20into%2015%20minute%20billing%20units%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2955195%22%20slang%3D%22en-US%22%3EThank%20you!%3C%2FLINGO-BODY%3E
Occasional Contributor

I'm fighting with the problem of converting time (h:mm) into 15 minute billing units, while always rounding down to the lowest number of full units. 
 
I'm using Microsoft® Excel® for Microsoft 365 MSO (Version 2110 Build 16.0.14527.20234) 64-bit on a Windows 10 PC.
 
For example, if the time I'm dealing with is 14 minutes, that would round down to zero units. 16 minutes would round down to 1 unit. 29 minutes would also round down to 1 unit. In the attached sample document:
 
0:15 = 1 unit
1:14 = 4 units
0:31 = 2 units
0:45 = 3 units
 
Any suggestions would be appreciated. Thanks.

2 Replies
best response confirmed by Tom_M_1969 (Occasional Contributor)
Solution

@Tom_M_1969 

In C5:

=QUOTIENT(B5,TIME(0,15,0))

Fill down.

Thank you!