Time Calc with rounding.

billreed7 · #1 06-26-2016, 04:56 AM

I need help with a formula, I want to put a start time and finish time into two cells and the answer needs to be to the nearest 15 minutes. ie 08.05 would be 0800, 07.25 would be 07.30 etc..

I have managed to find this that does the basic bit but not the rounding out.

=IF(C1<B1,((C1-B1)*24)+24,(C1-B1)*24)

but I find to put time in I need to put colons in and I would prefer to just type 0730 and not 07:30,I thought the time format would allow that but all I get is strange numbers coming up.

any help greatly appreciated

Bill Reed

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Rounding Up or Down depending on Start & End time	richardst	Excel	4	06-21-2016 06:03 PM
Rounding to nearest 0.25	Guloluseus	Excel	5	10-27-2015 11:28 PM
Trying to create a formula to calc if I add x new accounts, I will have to hire y tech/support ppl	glen123	Excel	7	07-28-2014 07:29 AM
XML List of lists in Excel or Calc	manofspider	Excel	1	08-05-2011 09:03 AM
Creating an Auto-Calc'd Date? Today+7 Days?	SoCalTelephone	Word	0	10-06-2010 10:27 AM