=ROUND(A1*1440,0)
HTH
Jason
Atlanta, GA
-----Original Message-----
Is there a way to convert a time that is formatted like
this: hh:mm:ss into
total minutes (mm)?
Example: the time is 3:30:22. I want to convert that
into 210 minutes (3
hours plus 30 minutes = 210 minutes) while rounding off
the seconds?
Thanks!
.
|