Thread: [Solved] Time is killing me!!!
View Single Post
 
Old 04-03-2007, 08:20 AM
wheedav1 wheedav1 is offline
Novice
 
Join Date: Apr 2007
Location: WA
Posts: 1
wheedav1
Default

Try this: formate column "A" to a military time format. Then place the following values or fomulas in the noted cells:

A1: 00:30 this is the lunch you want to subtract out
A2: 08:00 this is start of the day
A3: 17:00 this is the end of the day
A4: =sum((A3-A2)-A1)
Reply With Quote