Template Formula Issue rsjenkins

S

SUPERFUTURE

wonderful yearly timesheet submitted by community user: "rsjenkins". The
formula for calculating total time in column E will not calculate the correct
total time from columns B and C when it goes from PM to AM. For example time
in: 9 PM and time out 1 AM.....columns E calculates the time as -21 hrs.
need help to fix the formula: telephone: 207.221.5234
 
J

JoAnn Paules

I would suggest contacting Microsoft about this. We are not MS employees and
can't make the necessary change.
 
R

rlajenkins

Hello,

I created the template you are having problems with. I never thought
to check it for 2nd/3rd shift functionality because I created it for my
coworkers here and we only work 1st shift. I will correct this problem
and post a new version soon. Thanks for your feedback.

Robert
 
R

rlajenkins

I have posted the new version (1.7). It should appear in the next 48
hours on the template website. The name is "Yearly Timesheet v1.7".
Thanks for your feedback.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

TEMPLATE FORMULA ISSUE w/rsjenkins 1
Calculate After hours 3
Need formula for calculating time 2
Biweekly timesheet formula error 3
Looking formula that SUM values with specific value in neighboring colum 2
Add time when working 3rd shift 0
Help with lots of formulas 3
Calculating time for 3rd shift 4

Top