Round the time

**SuddenImpact** · 02-08-2015, 01:33 AM

Hello,

Im on to the next job and next project...

We have to enter employee times here, we use millitary time without the : so 4pm is just 1600.. Im looking for a way to have excel either display an alert if not rounded to the quarter hour, or just automatically change it.

ex: 1602 should be 1600 or 1609 should be 1615.

any help is appriciated!

**MarvinP** · 02-08-2015, 01:40 AM

Hi,

You need the MRound() Function. See:

http://excel.tips.net/T002186_Rounding_Time.html

**JieJenn** · 02-08-2015, 01:43 AM

Assume your entry is in A1. Enter this formula in B1. =TEXT(LEFT(A1,2),"#00")&TEXT(MROUND(RIGHT(A1,2),15),"#00")

**SuddenImpact** · 02-08-2015, 01:55 AM

Thanks so much guys!

**SuddenImpact** · 02-08-2015, 02:01 AM

Actually... is there a way i can use this with vba to cover a range of cells?

**SuddenImpact** · 02-08-2015, 02:40 AM

Im trying to do something like:

HTML Code:

but I get a compile error on the #

any thoughts?

Round the time

LinkBack

Thread Tools

Rate This Thread

Display

Round the time

Re: Round the time

Re: Round the time

Re: Round the time

Re: Round the time

Re: Round the time

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Round the time

[SOLVED] round up time unless already at the desired time value

[SOLVED] Round Time?

[SOLVED] Round down for time

Round UP Time

Bookmarks

Bookmarks

Posting Permissions