I have the basic time value formula, but I am having two problems;
The first is with this Total Comp Time formula:
=TEXT([Start Time]-[End Time],"h:mm")
It does display the difference in time as hours and minutes 1:30 as shown in the image. I would prefer it to show 1.5 because when the time is being manually deducted as 1, .5, or .25 of an hour (Comp Time Taken ex.in the image .5) the calculated column Comp Time Left is not accurate.
The formula being used for Comp Time Left:
=TEXT([Total Comp Time]-[Comp Time Taken],"h:mm")
Part 2 of my problem is I only wanted Total Comp Time to appear only if the "Status" column says "Approved"
I started on this formula below, but I can't seem to get it to work:
=IF([Status]=Approved, TEXT([Start Time]-[End Time],"h:mm"), “0”)