Thread: Seconds
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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?