DrunknMunky14
New Member
- Joined
- Jun 4, 2014
- Messages
- 15
Hi all,
Been a while since I last posted here.
I'm trying to create a time sheet which takes hours and minutes but not the time.
For example, a job takes 18 hours and 23 minutes and come out of a CSV file as 18:23, but the allocated time is only 15 hours (shown as 15:00), I want to be able to get -3 hours and 23 over the allocated time as -3:23.
Right now I'm getting thrown a #VALUE! error because time can't be negative.
What is the right cell format to achieve this?
Been a while since I last posted here.
I'm trying to create a time sheet which takes hours and minutes but not the time.
For example, a job takes 18 hours and 23 minutes and come out of a CSV file as 18:23, but the allocated time is only 15 hours (shown as 15:00), I want to be able to get -3 hours and 23 over the allocated time as -3:23.
Right now I'm getting thrown a #VALUE! error because time can't be negative.
What is the right cell format to achieve this?