Subtracting Dates

**CoachBarker** · 04-13-2009, 08:11 AM

I have 2 cells in a row that are times, it has been a while since I did any work in excel. I want to take the first cell as start Time, the second cell is end time and I need to subtract them and put the total in a cell called Hours. What is the correct format to use and how would I do the subtraction.

Generally start time will be AM and End Time will be PM.

Thank you for your help
CoachBarker

**NBVC** · 04-13-2009, 08:37 AM

Probably something like:

=(F1-E1)*24

Where E1 contains start time and F1 contains end time...

format the cell as General or Number...

**CoachBarker** · 04-13-2009, 09:50 AM

Now if I take a 30 minute lunch every day, say one column called Lunch, if it says Yes I took a lunch and want to lose .5. if it is blank subtract nothing.

DaysWorked.JPG

**NBVC** · 04-13-2009, 09:52 AM

Try

=(D3-B3-IF(E3="Yes",0.5,0))*24

**zbor** · 04-13-2009, 09:54 AM

-if(e10="y";0,5;0)

**NBVC** · 04-13-2009, 09:57 AM

Originally Posted by zbor

-if(e10="y";0,5;0)

Please read entire thread and try not to confuse the situation.

**CoachBarker** · 04-13-2009, 10:47 AM

That does work in the first row, but then in the rest of the Week 1 for totals I get -6,-4,-4,-4.

**NBVC** · 04-13-2009, 11:28 AM

Please post the actual worksheet in .xls format so that we can see what exactly you need.

**CoachBarker** · 04-13-2009, 01:16 PM

I've got it to work, had a format wrong on the cells. Thanks for your quick reply to my first post, I haven't really done any excel work since school.

Thanks
CoachBarker