Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert hours and minutes in time format into fractions of hours.. | Excel Worksheet Functions | |||
How can I convert fractional hours to minutes? | Excel Discussion (Misc queries) | |||
convert hours and minutes to minutes | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
How do I convert Military Time to minutes? | Excel Worksheet Functions |