Thread: Minutes
View Single Post
  #4   Report Post  
Jason Morin
 
Posts: n/a
Default

=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!
.