Prev Previous Post   Next Post Next
  #1   Report Post  
bob
 
Posts: n/a
Default Minutes

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding minutes to time Randberger Excel Discussion (Misc queries) 4 January 19th 05 08:49 PM
convert minutes into hours:minutes tlf713 Excel Worksheet Functions 3 December 15th 04 10:42 PM
Time sheet set up specifically HT New Users to Excel 5 December 5th 04 05:56 PM
calculate average hours and minutes llstephens Excel Worksheet Functions 4 November 30th 04 03:47 PM
Minutes and Seconds bob Excel Worksheet Functions 6 November 29th 04 01:21 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"