Time -Converting Rounding displaying
 

Hello... I am kinda new to all this.. I hope I can find my way back to
see if anyone can help.

What I am trying to do is have an excel file that currently displays
Time like this:

A B
5:45 AM
6:15 AM
12:55 PM
1:15 AM

To do this : I need the time rounded down to the last half hour so
that in column C it would take column A1 which is 5:45 to be displayed

in column C1 as 5:30 A2 would be C2 as 6:00.

A B C D
5:45 AM ?? 5:30 5:30
6:15 AM ?? 6:00 6:00
7:28 PM ?? 7:00 19:00
12:55 PM ?? 12:30 24:30 or 00:30
1:15 AM ?? 1:00 1:00

Time -Converting Rounding displaying
 

To round a time down to the previous half hour

=FLOOR(A1,"00:30")

format as time


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=564036