View Single Post
  #8   Report Post  
John_Franco John_Franco is offline
Junior Member
 
Location: Quito
Posts: 2
Send a message via MSN to John_Franco Send a message via Skype™ to John_Franco
Default

Quote:
Originally Posted by John_Franco View Post
Just subtract, use -

Forget the date format, Excel dates are sequential numbers
Your result will be 2.326388889

What does this mean?

You have 2 days and 0.326388889 time

Convert 0.326388889 to time format 37:30:55 for example and done

Learn more about excel dates, visit: http://www.excel-spreadsheet-authors...xcel-date.html