Rounding seconds

K

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
 
C

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 [email protected]
 
Top