View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
PCERM
 
Posts: n/a
Default More than calculations in time

I have set up a time sheet and want the minimum time taken at lunch to show
no less than 30 minutes. At present there are start and finish times for
both am and pm. The lunchtime column is a simple calculation taking the
second start time from the first stop time thus producing a time figure ie
00:45, 00:20 etc. I want to change this to show that a minimum of 30 mins
has been taken irrespective of what has actually been taken. Can anyone help
please?

Thanks

Peter