Time function for timesheeets

M

Mark McDonough

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.
 
M

Marcelo

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:
 
B

Bob Phillips

=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)
 
Top