Forum Moderators: coopster

Message Too Old, No Replies

excel type calculations on a website timecard

global modification like excel

         

steakster

1:59 am on Nov 21, 2009 (gmt 0)

10+ Year Member



I have a custom website (PHP & HTML) for scheduling staff - similar to a time card. Daily there are about 50 people working. The programming has fields for the 'In' times for each person. They are scheduled to arrive at work at different times of the day. If I wish to change all their 'In' times by the same value, I need re-enter the new times manually.

I'm looking for the ability to globally change all their 'In' times by the same value. IOW, everybody's 'In' time could be advanced by one hour - while preserving their different schedules. For example, Steve would go from 2:30PM to 3:30PM. Annie would go from 4:00PM to 5:00PM This is similar to Excel's ability to change a column of numeric values like a calculator.

How might this be accomplished? Thanks!

StoutFiles

2:18 am on Nov 21, 2009 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



Assuming this data is in a MySQL database, you would have a while loop pull out each time field and add an hour for every row in the field. Is this what you're talking about?

steakster

2:25 am on Nov 21, 2009 (gmt 0)

10+ Year Member



Yes. Sorry, I forgot to mention that it has a MySQL database.