Computers and Technology, 02.12.2019 18:31 coolfreekid3

Raul is setting up an excel spreadsheet to track how many hours his employees work each day. for the first worker, he has inserted the formula "=(i3-h3)” into cell j3.

raul needs to see a number of hours but instead he sees a decimal. he knows the employee worked more than 0.35 hours that day. what should raul do to make j3 show a number of hours?

a. insert “*24” at the end of the formula

b. reformat j3 as a general number

c. insert “hours” after the equal sign in the formula

d. change the order of the cells referenced in the formula

Raul is setting up an excel spreadsheet to track how many hours his employees work each day. for the

Answers: 1

Show answers

Answers

Answer from: thevampsrock3

The key to solve this number time format in Excel lies in understanding the simple seconds, hour and day calculations together with cell referencing. Cell referencing stands for the cell names where we will be performing our formula.

Explanation:

Numbers in Excel comes in various format. One of the headache from it is Excel often recognize times (x) as a decimal even when we are talking about time or hour. The key to solve this number time format in Excel lies in understanding the simple seconds, hour and day calculations together with cell referencing. Cell referencing stands for the cell names where we will be performing our formula.

The formula that we need to put in to cell J3 should have an idea like this: = (Clocked out - Clocked in) x 24

You can just use a simple formula by applying subtraction operation using from your clocked out / time out to your clocked in / time in. The answer will be the difference of this two times then you should multiple it to 24 which stands for 24 hours in one day.

Another thing, you must use the INT function to make sure that our answers in excel will be rounded off to the nearest integer. We definitely don't want any decimals in any of our cells.

Therefore the formula should look like this in cell J3: = INT((I3-H3) *24).

Almost a similar idea can be applied if we want to solve for the MINUTES between two times. Instead of using 24, we must use 1440 instead. Now, why do we need to use 1440? 1440 stands for the total minutes that we have for a single day. (24 hours * 60 minutes = 1440 minutes)

Therefore the formula should look like this: = ((I3-H3)*1440).

Answer from: Quest

Hey and for giving me the chance to serve uthe puzzles game can a smart person and it can grow your brain.hope l have a good day.

Answer from: Quest

Answergive credit to sources you used in your writing.

Another question on Computers and Technology

Computers and Technology, 22.06.2019 05:30

The total revenues for a company are $150,223 and the total expenses were 125,766. if you are calculating the net income, which of these spreadsheets would you use? insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2-b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2+b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2/b3. the formula should be showing in the formula bar. insert a spreadsheet with $150,223 in cell b2 and 125, 766 in cell b3. enter a formula =b2*b3. the formula should be showing in the formula bar.

Answers: 3

Answer

Computers and Technology, 22.06.2019 15:30

When creating a budget, log fixed expenses before income. after income. after savings. at the top.

Answers: 1

Answer

Computers and Technology, 22.06.2019 19:50

Write a car class having two private member variables called tank and speed. write public methods called pumpgas and gofast. the method pumpgas gets an integer for gas that must be pumped. that value needs to be added to tank (no more than 20 gallons). it must return the amount of gas that is purchased ($4 per gallon). the method gofast should increase the speed by 5 each time it is called.write a constructor for the above class that initialized both variables to zero.write a tostring to display both the tank and speed when the car is printed.modify the car class to implement the interface comparable and an interface called carinter having the public methods in carinter.write the main program to create an array of size 5 of type car. create 5 car objects having each location of the array to refer to one of the cars. test the pumpgas, gofast, equals method on the array items. write an enhanced loop to print all the car values (using a tostring written last time).write a generic method to find the minimum of four items. pass int, double, char, string and car objects to test this method.

Answers: 1

Answer

Computers and Technology, 22.06.2019 21:00

Kirk found a local community college with a two-year program and he is comparing the cost with that of an out-of-state two-year school. what is the expected total cost for one year at the local community college if kirk lives at home? what is the expected total cost for one year at the out-of-state school if kirk lives on campus?

Answers: 2

Answer

You know the right answer?

Raul is setting up an excel spreadsheet to track how many hours his employees work each day. for the...

Questions