I have a number of projects with a time in days allocated. I work on each project, it could be a day/half day/hour at a time. I want to display time allocated in one column, time spent in another and time remaining in another.

Example

Project 1
12 days allocated - 12:00:00 (day,hour, min)
1 Hour spent - 00:01:00 (dhm)
Time remaining - 11:06:30 (dhm)

Working day is 7 and a half hours


I have tried a number of different formulas but cant seem to find one that works. I want to amend the time spent column as I spend time on a project and for it to automatically calculate the time remaining.


Many thanks
Craig