Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How to subtract time in an excel sheet for time sheet?
column I Column K column M column o
Time in time out Minus Lunch total
9:00 am 5:00 0.5 8
i need help writing an equation to subtract the two times and subtract the lunch so that all i have to do is input the times and lunch break and the total will asutomatically show up, thanks !!!!
2 Answers
- Anonymous9 years agoFavorite Answer
=ABS(INT((I1-K1)*24))-M1
hope this helps
Source(s): http://www.learnexcelmacro.com/ - ?Lv 45 years ago
You can use either a cell reference or a number typed in the formula, so I'll show you both ways, first with just numbers. =3*2 produces 6 =3+2 produces 5 =3-2 produces 1 =3/2 produces 1.5 If you had a 3 in cell A1 and a 2 in cell A2, the formulas above could look like this: =A1*A2 produces 6 =A1+A2 produces 5 =A1-A2 produces 1 =A1/A2 produces 1.5