How to calculate work hours in Excel? Solved

Question

Hello, I would like to know how to calculate my working hours with Excel.
Example

Monday 8:00 to 16:30
Tuesday 8:15 to 16:00
Wednesday 8:45 to 15:00
Thursday 8:00 to 15:45
Friday 8:15 to 15:45

On top of that, I want the total for the week but also how much that amounts to with my salary which is $18/hour

Thank you for explaining how to calculate everythingConfiguration: Windows XP
Internet Explorer 6.0

ROUVIEREV · Accepted Answer

Hello,

Just a reminder that time is counted in base 60.
60s = 1 minute
60 minutes = 1 hour
24h = 1 day

With a rule of three, we can convert hours and minutes into hours and hundredths of an hour.

60 minutes correspond to 1
15 minutes correspond to 0.25
30 minutes correspond to 0.5
45 minutes correspond to 0.75

1h30 corresponds to 1.5 hours.

If you earn €18 per hour:

you can either calculate 46.5 x 18 to get your salary
or calculate 46h x €18/h + 0.5h x €18/h, which yields the same result.

Do not confuse 46h30, which is 46.5h, with 46h50, which is 46h + (50x1/60), or 46.83h.

Note from Jeff: The Orplan calculator can do this for you:
http://orpsi.com/calculs-heures-minutes/Orpcalc.exe

ROUVIEREV

julie1602 · Answer

You must write your time in the cell, and to calculate from the top, in FX do =click on the cell you want to count - the other cell "enter" e.g. ( =B1-A1)
08:00(A1) 16:30(B1) 08:30(C1)
08:15 16:00 07:45(C2)
08:45 15:00 06:15(C3)
total 22:30(C4)
add all the cells to get the total e.g. ( =C1+C2+C3)

Good luck

dudu134 · Answer

Hello, in accounting, hours are calculated as follows:
0.25 = a quarter of an hour
0.50 = half an hour
0.75 = three-quarters of an hour
1.00 = one hour
so
46h50 = 46h30
--
I hope I have helped you,
Please remember to mark resolved for all your solutions found.

Mike-31 · Answer

Hi,

As DUDU said, in accounting we calculate in decimal,

assuming that in C5 you want to enter a time value, for example for 4 h 15 you enter 4.15 and in another cell you enter the formula below which will convert 4.15 into 4.25 and this is the value you should multiply by $18 or another value

=((C5-TRUNC(C5))/60*100)+TRUNC(C5)

Best,

__________________________________________________________________

Need help. On the forum, volunteers take the time to decipher your sometimes confusing explanations and offer their knowledge. Once a solution is found, please have the courtesy to mark your status as resolved. This way, your problem can be classified and serve as a reference for others with similar cases.

Sem-Coluna · Answer

I propose something simpler... :

For those who have trouble with computers and Excel, we will default to a table where the start time will be in cell [C6] & the end time will be in [D6]

So we want the result in the third cell to their right: [E6]

E6 ==> ~~=SUM(24-(C6-D6))~~

Of course, to do this properly, you will simply need to select ALL the cells where your hours are noted and the cells for your results (to avoid selecting them one by one, which can take some time ;) )

Once the selection is made, right click ==> cell format ==> [category] Time ==> then choose the option "13:30"

And there you go, just note your hours, not forgetting of course to include your ":" between the hour and the minutes even if it's [20 : 00]

There you go, I hope I was clear enough =)

Oufla · Answer

There's an app on iPhone and iPad that's pretty good too, and it's part of my favorites now. It allows you to easily add, subtract, divide, etc. hours.

free: https://itunes.apple.com/us/app/calculatrice-a-heures/id956859838?l=en&ls=1&mt=8

paid (ad-free): https://itunes.apple.com/us/app/time-calculator-premium-addition/id1048440277?l=en&ls=1&mt=8

sanfroiniloi · Answer

A great online calculator to calculate your working time with conversion to decimal hours. http://www.fanchcreation.eu/

How to calculate work hours in Excel?

7 answers

How to change sources on a grundig universal remote?

Is tokyvideo a reliable site? what are your opinions?

Locate a turned-off phone with its imei.

I accidentally liked a photo on instagram.

Delivery address track718

Dymo letratag ribbon blockage

Mouse wheel that changes the sound???

My google chrome homepage is shifted to the right.

Notice shows wr30 m

Keyboard locked: what to do?