Convert number to time (hh:mm)

[barbarapoblocka]

I have two columns and they both represent time. I'd like to substruct the second column from the first, but they are in the different formats.

Does anyone have an idea how to transfer the format of the second column so it matches the first one? (hh:mm:ss)

[m_woolf · Accepted solution]

If Length2 represents hours, you can format it using:

=time(Length2/24,'h:mm:ss')

[marcus_sommer]

As far as dates/times are really dates/times which means that they are numeric you could calculate with them without any formatting - in your case probably something like: interval(Length - Length2, 'D hh:mm:ss') - whereby it might be that Length2 is greater as Length because some values are greater as 1 which means it is more than 24 hours.

- Marcus

[barbarapoblocka]

it worked, thanks! 🙂