Calculating time difference in seconds.

[ava_h]

I need to calculate time difference quickly as I monitor a phone call from a specific point in the conversation. I'd like to enter it into a cell as a decimal like .59 (59 second mark) and it might would end at 1.30 (1 min 30 second mark). What formula can I use to get the correct time difference of 31 seconds? Or is there an easier way to enter and calculate the time?

 

[prabby25101981]

Shouldn't you enter .59 as 0:59 and 1.30 as 1:30? If you then subtract 0:59 from 1:30, that should give you 0:31, which is what you want...

 

[barry houdini]

For excel to recognise the values as seconds you need to enter like

0:00:59 and 0:01:30

[0:59 will be interpreted as 59 minutes]

If you put those two in A2 and B2 respectively then you can just subtract in C2, i.e.

=B2-A2

and the result should be 0:00:31