Create two calculated fields to determine normal and overtime hours between a start and finish time.

(0) Share

Report

Posted on by Community Member

Hi,

I have a custom entity which documents labour costs and which has two standard start and end date/time fields.

The entity currently performs a calculation to determine the total hours between the two date/time fields and returns this in number of hours.

This is fine as far as it goes, however what I want is to create two calculated fields which work out number of hours which are normal time and number of hours which are OT.

For instance first calculated field would show total of hours that were between 0800 and 2000

Second calculated field would show total of hours that were between 2000 and 0800

I could then use these two calculated fields in a third one which would multiply these hours by the respective unit rate for both standard and over time.

*This post is locked for comments

I have the same question (0)

All responses (1)

Answers (0)

TomSmelser 1,570 on at

Like (0)

Report

RE: Create two calculated fields to determine normal and overtime hours between a start and finish time.

One option would be to create a custom workflow activity. Here is a link to get you started.

msdn.microsoft.com/.../gg509048.aspx

Was this reply helpful? Yes No