please help with Time interval

[gow75]

I have an excel sheet that i need to take 2 columns that have 2 different decimal numbers and convert them to Time HH:MM:SS then have a column display the output of subtraciton of both of the difference. I attached a screen shot.

[Jonmo1]

Try

=TEXT(F2,"00\:00\:00")-TEXT(E2,"00\:00\:00")

[FDibbins]

welcome to the forum

Hopefully, Jon's suggestion works for you

if not, please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info)

[gow75]

thanks jonmo 1 i dont think that worked or i didnt do it correctly. I put the formula in G2 cell =TEXT(F2,"00\:00\:00")-TEXT(E2,"00\:00\:00") see the result in another .jpg i need it to post the diffrence in seconds or in a time format that is more legible.

Thanks

thanks FDibbins, I realize that posting sensitive data should never be posted. thank you

[Tony Valko]

You just need to format the formula cells as h:mm:ss.

[Jonmo1]

format the cell with the formula as a TIME instead of NUMBER

[gow75]

Thank you Guys!!!

[Jonmo1]

You're welcome.