S
STELFOXJ
Hi everyone,
I hope you can help.
I am trying to create a spreadsheet which will calculate time values.
The sheet I am creating will be a time bank statement whereby a
customer has a number of hours available.
We then enter times of how long time has been spent working on various
jobs. At the end of the spreadsheet it will then say how much time is
left.
What I want the sheet to do is present a negative value for if they
have used more time than was available. For example, if a customer has
2 hours, and we spend 3 hours working for them, they are 1 hour
'overdrawn'.
DOes this sound relatively straightforward? I managed to get it to
calculate times, but when there was a negative value, it went a bit
nuts!!
Any help would be great!
Thanks
James Stelfox
I hope you can help.
I am trying to create a spreadsheet which will calculate time values.
The sheet I am creating will be a time bank statement whereby a
customer has a number of hours available.
We then enter times of how long time has been spent working on various
jobs. At the end of the spreadsheet it will then say how much time is
left.
What I want the sheet to do is present a negative value for if they
have used more time than was available. For example, if a customer has
2 hours, and we spend 3 hours working for them, they are 1 hour
'overdrawn'.
DOes this sound relatively straightforward? I managed to get it to
calculate times, but when there was a negative value, it went a bit
nuts!!
Any help would be great!
Thanks
James Stelfox