How do I formulate Times into Hours, when building a spreadsheet, using Microsoft Works?

Question

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     (??????)

IXL@XL · Accepted 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.

Anonymous · Answer

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.

How do I formulate Times into Hours, when building a spreadsheet, using Microsoft Works?

Related Questions

Trending Questions