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?

Hi,

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

Mike

"Pass-the-Reality" wrote:

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?

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

"Mike H" wrote in message
...
Hi,

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

Mike

"Pass-the-Reality" wrote:

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?