Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be 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 do I formulate Times into Hours, when building a spreadsheet, using Microsoft Works?
I am building a spreadsheet. On this spreadsheet there will be times (HH:MM). I want to calculate two specific times into a total number of hours. Does anybody know the formula I need to enter to formate that cell??? I am using Microsoft Works.
EXAMPLE: In Parenthesis is how the cell is formated
CELL B3= Time In (12:00 AM)
CELL C3= Time Out (12:00 AM)
CELL D3= Total Hours (??????)
2 Answers
- IXL@XLLv 71 decade agoFavorite Answer
Start time in B3, finish time in C3. In D3 type
=IF(B3>C3,(1+C3)-B3,C3-B3)) Format all cells as hh:mm and enter times as military time ie 1:00 PM is 13:00.
- Anonymous4 years ago
touch the Occupational secure practices and wellness administration (OSHA) and document that your boss is over working you and intentionally putting your wellness in possibility. additionally study "The Jungle" via Upton Sinclair. it quite is all approximately hideous exertions circumstances which sounds precisely like what you and your coworkers could desire to be experiencing.