LibreOffice pay check

[doctorvell]

Hi there,

I am wondering about how to do something in CALC.

I have the following (which does work):

A1/A2/A3/A4/A5/A6/A7=start time work (as hh:mm a/pm)
B1/B2/B3/B4/B5/B6/B7=end time work (as hh:mm a/pm)
C1/C2/C3/C4/C5/C6/C7=hours worked (as hh:mm)
C8=hours worked for week (hh:mm)
C9=base pay rate (as $##.##)
C10=base paycheck (as $###.##)
C11=overtime pay rate (as $##.## - which is 1.5 of C9)

C12, C13, C14 is where I am having problems
I would like to do the following

C12=40 minus C11 (the amount of time of overtime (40 hours) (even minutes shown as hh:mm))
C13=C12 times C11 (pay amount of the overtime hours only shown as $###.##)
C14=C13 plus C10 (the amount earned with overtime shown as $###.##)

[PKG]

@doctorvell

C8=hours worked for week (hh:mm)

If you work less than 24 hours a week this format is fine, if this is not the case use [hh]:mm.

[doctorvell]

I know it is going to be anywhere from 38 to 40+ hours per week, so that isn’t an issue.

[karolus]

@PKG

less than 24 hours a week this format is fine, if this is not the case use [hh]:mm.

@doctorvell

38 to 40+ hours per week, so that isn’t an issue.

something is wrong in your logic!

[doctorvell]

I just need to know how to get the difference between 40 hours and the amount of hours worked, so if I worked 42 hours and 30 minutes it would say 2:30 and then with that hour it would calculate overtime for that amount. Then with that figure I would add it to the hours worked without the overtime (the 40).

[karolus]

@doctorvell

40 hours and the amount of hours

=5/3 - C11

[fpy]

@karolus

5/3

= 40 / 24

Calculating Time Differences

[Wanderer]

@doctorvell

I just need to know how to get the difference between 40 hours and the amount of hours worked

Time in spreadsheets is usually a fractionvof a day/24 hours. To see this format your cells as floating points and you will find 12:00 as 0.5, 6:00 as 0.25. So you can directly subtract 16:00-8:00 = 0.333.
.
If you wish to mix hours in this you have to transfer them in the same range 40 hours → 40/24 = 5/3 => 1.6666. (You may recognize the fraction given by karolus)
.
Keep an eye on timestamps, wich include the date as number of days left of the decimal. Formatting as time may not show the part left of decimal point. Mixing time and timestamps may work or cause trouble.
.
PS: Link to help on this topic in the comment above by fpy, so no need to repeat it here…