Calculate Double Time Variable

darthanian

New Member
Joined
May 4, 2016
Messages
1
Hi all,

I've been reading this board long time and it's helped a great deal on other subjects. I could not find a reference for this. Never been much good with regular expressions, more of a hardware guy.

As of now my repair shop uses a MS Access database to track my tech's times per work order. I'm not sure if the previous person who set this up simply found this form online or designed it, i'm thinking the former. As of now when we enter "OUT" into the work order field it takes that time minus his total time in a day. So he worked worked 7 hours and 1 hour of OUT. Would show accordingly. Well management wants me to be more specific about what kind of "out" time it is. So now instead of using out we want to use this format options. Year, Employee#, PTO/Sick. So the work order will be 165555P for a pto time allotment. Looking for options. It needs to subtract from time worked, and either add to the "OUT" field or i was thinking i might need to add another field..

Here are the current expressions calculating the time

=HoursAndMinutes(Sum(IIf([Job No]="Out",([out]-[in]),0)))+" Hrs. Out"

=HoursAndMinutes(Sum(IIf([Job No]<>"Out",([out]-[in]))))+" Hrs."


timeshot.jpg
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,213,546
Messages
6,114,254
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top