Question

Locked

Daily Rate weekly Timesheet (two rates available)?

By rdegetaire ·
I am need of producing a weekly timesheet that allows for two rates to be chosen from. Ideally, the template in Office 2011 for mac is perfect, except it is for hourly rates. I want to be able to choose from a drop down list (Travel day or Offshore Day) in one column, the column on the end for totals will automatically display the appropriate rate for the selection made. Is there anyone that can help me with the formulas? Thanks in Advance

Rdegetaire

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

If function?

by Noshmon In reply to Daily Rate weekly Timeshe ...

Hi,

Would you be able to get the user to manually input a T for travel or and O for offshore?

For example, if the hourly rate for travel is 5 and the hourly rate for offshore is 10 then:
=IF(B2="T",C2*5,IF(B2="O",C2*10))

In B2 the user should put t or o (case insensitive). In C2 the user puts the hours worked. This gives room for titles. Obviously a key would be needed. If the user puts anything other than a T or an O in then the for returns FALSE.

I can work on this if you need me to. Let me know

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums