Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Time Manipulation | Excel Discussion (Misc queries) | |||
conditional formatting with time values | Excel Discussion (Misc queries) | |||
Time Calculations | Excel Worksheet Functions | |||
time interval calculations in excel | Excel Discussion (Misc queries) | |||
Date and time calculations | Excel Discussion (Misc queries) |