Displaying Time in hours

Lynda53 wrote:

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

With hours in text format, you can try this:

=REPLACE(A3,3,0,":")-REPLACE(A2,3,0,":")-"00:30"

adding the colon to text, Excel cast the string in time values and calculate the difference. 

The final string "00:30" which indicates your break, you can replace it with a reference to a cell containing the half hour or any other custom intervals.

Bye.