Seconds

P

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?
 
M

Mike H

Hi,

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

Mike
 
D

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

Mike H said:
Hi,

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

Mike

Pass-the-Reality said:
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?
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Difference between two times in seconds 1
Shortcut for current Time in hh:mm:ss 2
years-months-days-hours 5
Date and Time (entering in the format of mm/dd/yyyy and hh:mm:ss ) 8
cells with hours, minutes, and seconds 4
convert dd:hh:mm:ss to seconds 5
Adding time durations 2
Time in Minutes and seconds 6

Top