Inserting seconds without the cell changing the value

Hello,

I use Excel to find out the effectiveness of my employees. My data comes from diffrent programs and in diffrent values (hours, seconds etc.)

I have no problem converting hours into second just by formating cell values to [ss].

However I'm facing problems when I have a value already in seconds. I want to insert the seconds to calculate the diffrence between my first value (hours converted to seconds) and value number 2 (already seconds). To do that, both collums need to be the same value - seconds - but I can't do this, because Excel wont let me insert seconds (I have formattet the cell to [ss]) without changing the value in the cell.

To type 00:00:1234 isn't a option since I got 200 employees and should do this manual.

I hope you guys can help me :-)

Kind regards,
Mads

If you want to extract only seconds from a time, you can use =second(Your_Time). If you want to convert hour to sec, you can use =convert(Your_Time,"hr","sec").

If both these solutions don't suit you, please post a dummy workbook for better understanding of your problem.

Hello and thanks for your answer,

I have the values listed and want to copy/paste them into excel who should know that the values is seconds.
Any suggestions for at solution to this problem?


Kind regards,
Mads

If you copy 1234 in a cell, and you want to convert it to time, you can use =time(0,0,1234). This will convert it to time.