Round a Time Stamp

jbfrank

Active Member
Joined
Oct 13, 2003
Messages
290
I have a formula in cell C1 that subtracts the time in B1 from A1. I'm left with hh:mm.

Is there any way to round that number up to the nearest quarter hour? For instance, if the time difference is 5h and 35m (5:35), I need this to automatically round up to 5:45.

Any ideas?
 

Some videos you may like

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,491
Members
412,669
Latest member
nickyon1
Top