Forum Discussion
Displaying Time in hours
I have a spread sheet where I record my work hours. Eg: 0700 (A2) - 1530 (A3) which equals 8 1/2 hours, then I take 30 minutes off for a lunch break, which leaves me with 8 hours. My formula is A3-A...
Enter the times (start and end) as 7:00 and 15:30. Excel should automatically recognize these as time values and format the accordingly. Then your formula can be =A3-A2-30/1440 as shown in the picture.