Rounding time
One way:
Since XL stores times as fractional days, 1 = 24 hours * 60 minutes =
1440 minutes. So,
=ROUND(A1*1440,0)/1440
Format as time, if necessary.
In article ,
Amy wrote:
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
|