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

Ten former members of the USC Song Girls told the L.A. Times they were mistreated and ridiculed while with the team. (David Dennis/Icon Sportswire via Getty Images)

USC's Song Girls have an ugly yet familiar story

'Jersey Shore' star arrested on domestic violence claim

Students gather Wednesday outside the Ohio Statehouse in Columbus to protest Tuesday’s shooting of Ma'Khia Bryant by Columbus police. (AP)

The chaotic moments before police shooting in Columbus

Geno Hayes with the Jacksonville Jaguars. (Getty Images)

Ex-NFL LB Geno Hayes, 33, reportedly 'fighting for life'

Police officers approach protesters after the death of Daunte Wright, in Brooklyn Center, Minn., on April 12. (The New York Times)

Chauvin verdict brings the police relief, resentment

'I don't believe for a second that you will actually do this'

Randy King, the tribal chairman of the Shinnecock Indians, at the site where the tribe plans to start construction of a casino on its reservation in Southampton, N.Y., March 12. (The New York Times)

The Indian tribe clashing with the Hamptons' elite

Scene from "The Price Is Right." (Yahoo Entertainment)

Elated contestants make 'Price Is Right' history

Lead singer Shock G of the alternative rap group Digital Underground. (Getty Images)

‘Humpty Hump’ of Digital Underground dies at 57

NBA veteran Jeremy Lin is leading a movement against anti-Asian racism in basketball and beyond. (AP Photo/Chiang Ying-ying)

Lin now leading fight against anti-Asian hate

Investigators confer during an investigation outside the Somers House Tavern, in Kenosha, Wis. (AP)

Man charged with killing 3 in Wisconsin tavern shooting

More trending news?Visit Yahoo Home

Promoted

spadezgurl22

Lv 6

spadezgurl22 asked in Computers & Internet Software · 9 years ago

how to subtract time in in excel for employee hours?

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 !!!!

1 Answer

Relevance

Anonymous
9 years ago
Favorite Answer
=ABS(INT((I1-K1)*24))-M1
hope this helps
Source(s): http://www.learnexcelmacro.com/

Still have questions? Get your answers by asking now.