I'm stuck. I'm trying to create a time sheet where if I enter time in decimal
format, it will display in hour format automatically. I also want it to
calculate the difference between the times (including lunch breaks). So, for
example, if I start at 9:45 am, I can input 9.75 (to be displayed as 9:45 am)
in A2, 17.00 in b2 (to be displayed as 5:00 pm), and a one-hour break in c2.
D2 would then calculate the total. I've experimented with different formulas,
but seem to run into a circular reference error. Any suggestions?

Thanks.