THREE "HOURS WORKED" FORMATS.....3RD ONE NOT WORKING

[JuicyMusic]

Hi, I spent a lot of yesterday reading some blogs about DATE & TIME formats in Excel and the consensus I read was that it can be difficult and tricky. I have this three column little table and the 3rd column isn't giving me the correct results if the manual entry in column F is

I have this three column little table. Employees can work over twelve hours, in case you need to know.

1) Manual entry will be in column F. It is for "how many hours worked" only. It won't be a time or an "o'clock".
2) The formula in column G is returning good results.
3) The formula in column H is giving me an AM or PM. It's giving me the same results as in col G and it should only give the round up or down to the next quarter hour depending on what is in column F.

Formula in col G:

=F7/(24)

Formula in col H:

=IF(F7="","",
MROUND(G7,"0:15"))

My data set snapshot will be attached since I can't install XL2BB. Thank you so much

 

[Fluff]

Col H in your image is giving the time to the nearest 15 mins.

 

[JuicyMusic]

Fluff, Yes it is giving me that correct round up to the next quarter hour. Not AM or PM.

For example, 14.27 in F should give me a 14.25 in column H - not 2:15PM. 14.27 would be how many hours someone worked - not a clock in time.

I added 0.47 as an additional entry so you can see. The result should be .5 not 12:30AM. I hope that helps. I wrote better column headers too. THanks!

 

[Fluff]

In that case use

=MROUND(F2,0.25)

 

[JuicyMusic]

SOLVED! Just taking out the ""? Wow thank you so simple wow. Plus I changed the format in the third column from Time to Number. Thank you !

 

[Fluff]

You're welcome & thanks for the feedback.