Mark Southgate
New Member
- Joined
- Jan 5, 2019
- Messages
- 1
HI
I am trying to produce a simple spreadsheet whereby I can monitor if staff working alone are overdue to phone in to say they have finished and are safe.
All I need is a column for time due to finish and another column that shows time (hrs Mins) elapsed. If that could change colour after say 30 mins that would be even better!
Clearly the data required is real time and time due to finish with a simple formula to calculate time since due to have finished but have tried loads of ideas on forums but can never get a formula to work using TIME functions. I appreciate you have to activate the sheet for real time to update.
Any ideas please??
Thanks for reading
Mark
I am trying to produce a simple spreadsheet whereby I can monitor if staff working alone are overdue to phone in to say they have finished and are safe.
All I need is a column for time due to finish and another column that shows time (hrs Mins) elapsed. If that could change colour after say 30 mins that would be even better!
Clearly the data required is real time and time due to finish with a simple formula to calculate time since due to have finished but have tried loads of ideas on forums but can never get a formula to work using TIME functions. I appreciate you have to activate the sheet for real time to update.
Any ideas please??
Thanks for reading
Mark