LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Time Manipulation BFiedler Excel Discussion (Misc queries) 0 September 15th 05 01:15 AM
conditional formatting with time values Access Idiot Excel Discussion (Misc queries) 2 September 13th 05 03:29 PM
Time Calculations Paul T Excel Worksheet Functions 1 April 23rd 05 04:02 AM
time interval calculations in excel Krishna Excel Discussion (Misc queries) 6 April 8th 05 02:57 PM
Date and time calculations Tony Excel Discussion (Misc queries) 2 January 8th 05 05:16 PM


All times are GMT +1. The time now is 06:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"