Convert hh:mm:ss to seconds?

  • Thread starter Thread starter Ed
  • Start date Start date
E

Ed

I am inputting two times as h:mm:ss and subtracting them. I am trying to
get the final answer as seconds. The only thing I can think of is trying to
use LEFT and RIGHT to separate hh, mm and ss, multiply to convert the hh and
mm to seconds, and then add to get total seconds.

One - the LEFT and RIGHT don't seem to want to work for me - I keep getting
decimal answers, even with a hh:mm:ss format.

Two - is there an easier way?

Ed
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MROUND time 2
convert to seconds 3
Video Timecode? 2
Sum of minutes and seconds times price? 2
Returning the first part of a workbook name 15
format second to hh:mm:ss should be simple but I'm stuck 10
Converting seconds to hh:mm:ss 2
convert dd:hh:mm:ss to seconds 5

Back
Top