Home » Forums » Open Source Learning Center » Question and Answer

Overtime Calcualtion

Submitted by sfynx on 14 March, 2013 - 11:04

Hi

Can someone help me to make some formulas to calculate overtime based on the following :-

weekdays including saturdays, overtime is paid 1.5x up to 2300 and beyound 2300 its 2x
and for sundays and public holidays overtime is paid for the first 8 hours its 2x and beyound 8 hours its 3x

thanks

‹ excel vba Excel Data Connections DSN resolution ›
»
Almir's picture

Can you provide info how your data is organized?

Submitted by Almir on 14 March, 2013 - 17:35.

Can you provide info how your data is organized? What is table structure, what data do you enter, in what format?

»
Almir's picture

Can you provide info how your data is organized?

Submitted by Almir on 14 March, 2013 - 17:34.

Can you provide info how your data is organized? What is table structure, what data do you enter, in what format?

»

I need to input day and date,

Submitted by sfynx on 15 March, 2013 - 04:47.

I need to input day and date, and overtime hours
depending on the day it is, then overtime is calculated daily

for weekdays, it is paid 1.5 up to 2300 hrs and after 2300 it is 2x
and sundays and p.holidays it is paid 2xfor the first 8 hours and then 3x

in my table, i will date and day, i need a chk to chk whether it is a public holiday, need to input overtime hours.

i need to find a way to calculate , the number of 1.5x, 2x and 3x hours for each day. and based on the number of hours i will be able to calculate it moneywise.

»
Almir's picture

Any work after midnight?

Submitted by Almir on 15 March, 2013 - 12:47.

Any work after midnight?

»

yes

Submitted by sfynx on 15 March, 2013 - 17:15.

yes

»