LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Ianukotnorth
 
Posts: n/a
Default Convert "Time Interval" in "hours : minutes : seconds" to seconds

I wish to compare the cost of telephone calls between various telephone
service providers available to me.
I have downloaded a list of itemised call made by me from my present
provider and I wish to compare the cost of each call if I had used
alternative providers.

I'm OK with the basic mathematical formulae - but I need to convert a "Call
Duration" in "hh:mm:ss" format to seconds.

(I could use the "Text to columns" facility and then multiply the " Minutes
Column by 60 and the hours column by 360 - and add the three columns together
but feel this is clumsy when there must be a "nicer - easier way)

Thanks for your help.

Ian M
 
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
Convert hours and minutes in time format into fractions of hours.. Akern Excel Worksheet Functions 4 April 21st 05 02:56 PM
How can I convert fractional hours to minutes? Speck Teck Excel Discussion (Misc queries) 3 March 4th 05 12:18 AM
convert hours and minutes to minutes idaho Excel Discussion (Misc queries) 2 January 27th 05 09:45 PM
convert decimal number to time : convert 1,59 (minutes, dec) to m agenda9533 Excel Discussion (Misc queries) 8 January 20th 05 10:24 PM
How do I convert Military Time to minutes? Rachael Excel Worksheet Functions 1 January 6th 05 10:01 PM


All times are GMT +1. The time now is 09:19 AM.

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"