Rounding seconds

[Kenneth Brown]

Hello All,

I need to calculate times to the second (hh:mm:ss) but display the
results to the nearest minute. However using the the hh:mm format
simply removes the seconds - how can I get Excel to round to the
nearest minute?

Thanks in advance,
K

 

[Chip Pearson]

Kenneth,

You can't use formatting to round the time value. You will either have to
live with the truncation provided by the hh:mm format, or actually round the
value in the cell with a formula like =MROUND(A1,1/60/24) .


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)