I currently have this formula:
=text(D2 - C2, "hh:mm:ss")
I need this formula to round up to the nearest 5 minutes.
I have tried
roundup(), but I'm not getting the result I need.
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
=mround((D2 - C2) * 24 * 60 + 5, 5) / 24 / 60
Format the result cell as Format > Number > Duration or another time number format of your choosing.
See this answer for an explanation of how date and time values work in spreadsheets.