help for over time calculation

[ganesan]

i have a1 column process hours and b1 column start date & time my shift time is 9amto 6 pm i need the particular process over time calculation.

 

[Hui]

Ganesan

Firstly, Welcome to the Chandoo.org Forums

Did you attach the correct file as the Column A1 doesn't match your description above?


Can you please be more specific with the question, assume we know nothing about your business or data layout

 

[ganesan]

sorry for the inconvenince here i have mentioned my problems detailed so that you can easily understand and help to him

In the B3 COLUMN CA operation start date& time B2 CA process hours. My shift time is 9:00 Am to 6:00 PM . But some days operator working on Befor 9:00 am(over time) & some process they will start 3:00 pm and contionusly working after 6:00 pm up to 8:00 pm (2 hours OT) . SO i want each processs wise over all over time calculation formula.

 

[NARAYANK991]

Hi Ganesan ,

Will the OT spillover across midnight ?

Will it happen that a person starts work after 6 PM on one day , and works till 3 AM the next day ?

Narayan

 

[ganesan]

Hi Ganesan ,

Will the OT spillover across midnight ?

Will it happen that a person starts work after 6 PM on one day , and works till 3 AM the next day ?

Narayan

NO WE ARE RUNNING IN ONLY ONE SHIFT SHIFT START TIME 9:00 AM AND END TIME 6:00 PM . But some days they are start work on 6 or 7 or 8 am and finish the work 7 or 8 PM SO i want befor 9:00 am and after 6:00 pm total work hours

 

[NARAYANK991]

Hi ,

See if this is OK.

I have done the formula for one process ; please copy this for the other 2 processes.

Narayan

 

[ganesan]

hi
this very help ful for to me . But i have some diffculty. Because i have 25 operation so i will create each operation like LMN COLUMN added like that i will add 25 operation the sheet will be going very big and seen the data also difficult . so can you make it single formula without LMN column if possible it will very helpful for me