# Rounding up a time to minutes

#### jpowell79

##### Active Member
Hi Guys,

I have a column of call duration values.

For example:

00:09:54
00:10:11
01:55:07
01:55:23
02:47:24
02:47:39
02:59:35
00:35:22
00:35:50

Is there a way we can roundup to the nearest minute, then represent this as a value, so based upon the example below, these values would now be shown as:

10
11
116
116
168
168
180
36
36

Thanks guys

### Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

#### VoG

##### Legend
Try

=ROUNDUP(A1*1440,0)

and format the result cell as Number.

#### Richard Schollar

##### MrExcel MVP
Hi

=CEILING(A1*1440,1)

copied down

#### al_b_cnu

##### Well-known Member
Hi, Try =ROUND(A1*24*60,0)

#### Evagrius Ponticus

##### Well-known Member
Well, this would work too, it has to be formated as number or general - though it's decidedly not as streamlined as the rest

=ROUND(HOUR(A1)*60+MINUTE(A1)+SECOND(A1)/60,0)

#### jim may

##### Well-known Member
There may (easily) be a shorter way, but this worked for me (copy down)

=IF(HOUR(A1)>0,HOUR(A1)*60,0)+ROUNDUP(MINUTE(A1),0)+1

#### jpowell79

##### Active Member
Thanks to everyone!

Worked great

thanks again

Replies
6
Views
439
Replies
1
Views
171
Replies
2
Views
82
Replies
4
Views
161
Replies
1
Views
317

1,191,367
Messages
5,986,249
Members
440,013
Latest member
DBB1

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back