Thread: [Solved] How to get cells to calculate time?
View Single Post
 
Old 09-29-2006, 08:43 PM
Ziggy1 Ziggy1 is offline
Novice
  
Join Date: Sep 2006
Location: Ont, Canada
Posts: 8
Ziggy1
Default
this will work as long as your hours stay with in one day

Format your Time Cells as Time and the cell with this formula as an Number format

=(EndTime - StartTime)/24
Reply With Quote