What formula can I use to achieve the following result

Start 8.30am
Lunch half an hour
Finish 5.30 pm

Total time = 8.3 is the result required but can't get it to work.

Time involved is 8hours and 30mins.

Hi Mark

imagine the start is on A1, the Finish on the B1, you can try:

=(B1-A1-0.0208333333333333)

this number 0.0208333333333333 is the 00:30 lunch time

hope this helps
regards from Brazil
Marcelo



"Mark McDonough" escreveu:

What formula can I use to achieve the following result

Start 8.30am
Lunch half an hour
Finish 5.30 pm

Total time = 8.3 is the result required but can't get it to work.

Time involved is 8hours and 30mins.

=end_time-start_time-time(0,30,0)

and format as time.

If you want it as 8.3

=INT((end_time-start_time-TIME(0,30,0))*24)+MOD((end_time-start_time-TIME(0,
30,0))*24,1)*0.6

formatted as general

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Mark McDonough" wrote in message
...
What formula can I use to achieve the following result

Start 8.30am
Lunch half an hour
Finish 5.30 pm

Total time = 8.3 is the result required but can't get it to work.

Time involved is 8hours and 30mins.