In excel, I can take a finish time (15:45) and subtract the start time (11:00), format the cell as a "general" type and come up with 0.197916667 which I can then multiply by 24 to get 4.75.
I have done the subtraction in sql to get the time 4:45, but want to display that as 4.75 in my asp.net/c# page.
How can I do that? When I try the different number formats it does not work. I also can't seem to get any further than 4:45 in sql either, where I would be happy to complete the formula if I could.