All,
Having a lot of diffidulty with this. I need to keep track of hours worked and relate to pay. However, im having issues with cells not updating and converting time to dollars.
Ex:
If I change the start time in C5, E5 will not update.
Also, when I attempt to total the hours (V3), it is not accurate.
Please see the attached document... any help is much appreciated!
Hi xforum142rlidax,
Try this in E6:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thanks, but this does not work. I have to hold shift and hit enter for E6 to update if I change the times.
Anyone else have a suggestion?
Are you entering the colon when you change the time??
I was not... but it does not change anything when I do.
With excel on automatic calculation and entering the colon - it works for my 2003 as is!!
And - try this in V3:
*V3 needs to be formatted as a number with no decimalsPlease Login or Register to view this content.
Last edited by xladept; 09-11-2012 at 04:19 PM.
I used a template for the calendar... auto calc was off!!!
sorry for the trouble.
take care.
No trouble - glad it's resolved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks