Seconds

[Pass-the-Reality]

I have a spreadsheet with two columns, Begin Time and End Time. The time
format is set to hh:mm:ss AM. I want to find the difference between the two
times, but in seconds. What formula would I write to subtract the times and
have the output response be total seconds?

 

[Mike H]

Hi,

When you've done the subtraction format the cell with a custom format of [ss]

Mike

 

[David Biddulph]

.... or if you want a number in seconds, use =(B1-A1)*24*3600 and format as
Number or General, not as Time.
--
David Biddulph

Hi,

When you've done the subtraction format the cell with a custom format of
[ss]

Mike

I have a spreadsheet with two columns, Begin Time and End Time. The time
format is set to hh:mm:ss AM. I want to find the difference between the
two
times, but in seconds. What formula would I write to subtract the times
and
have the output response be total seconds?