Rounding time
In addition to the posted ROUND solutions, if you have the Analysis ToolPak
add-in added in...
=MROUND(F1,TIME(0,1,0))
appears to also work.
Rick
"Amy" wrote in message
...
Hi,
I would like to round time to the nearest minute in Excel. For example
have
a time that is 7:03:01 and 7:03:59 and they both appear as 7:03 with the
format h:mm when I would prefer they appear as 7:03 and 7:04. Can anyone
please tell me how I can do this.
Regards,
Amy
|