Excel - How do I round a date type to the next hour if it is more than one minute

0 votes
So I have a hh:mm: ss date type and I want to round it to the next hour if it is even 1 minute above 0.

Example: 14:01 -> 15:00 11:24 -> 12:00

Tried using =MROUND(A1,"1:00") but it just rounds it to the closest hour not to the next hour as I need.
Mar 27, 2023 in Others by Kithuzzz
• 38,010 points
208 views

1 answer to this question.

0 votes

Add almost 30 minutes and it'll get you what you need.

=MROUND(A1+TIME(0,29,59),"1:00")
answered Mar 27, 2023 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer
0 votes
1 answer

How do I align a UserForm next to the active cell?

Answer to Q1 - Yes, it's correct. In ...READ MORE

answered Oct 27, 2022 in Others by narikkadan
• 63,420 points
980 views
0 votes
1 answer

Is there a way to test a formula result in excel and type it only once, all within one cell and not using a user defined function?

Use the Let function: =LET(Value,A1+B2+C4+G3+B4,IF(Value>10,"No",Value)) I hope this helps ...READ MORE

answered Jan 9, 2023 in Others by narikkadan
• 63,420 points
412 views
0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

answered Jan 19, 2023 in Others by narikkadan
• 63,420 points
664 views
0 votes
1 answer

Date format conversion in Excel

You appear to be misunderstanding the point: ...READ MORE

answered Jan 8, 2023 in Others by narikkadan
• 63,420 points
278 views
0 votes
1 answer

Is there an efficient way to do this excel function

Use vlookup(): VLOOKUP(E2,$B$4:$C$8,2,1) READ MORE

answered Feb 7, 2023 in Others by narikkadan
• 63,420 points
226 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,426 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16, 2022 in Others by Edureka
• 13,670 points
1,484 views
0 votes
1 answer

Excel-VBA - How to identify Target range (more than 1 cell) is deleted in a Worksheet_Change function?

You misunderstand the purpose of the function ...READ MORE

answered Sep 23, 2022 in Others by narikkadan
• 63,420 points
3,125 views
0 votes
1 answer

How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

answered Oct 24, 2022 in Others by narikkadan
• 63,420 points
533 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP