What does your formula represent ? ( always easier when one can see a sample sheet)
To deduce 1.5 hours from start time : start_time-1.5/24
To add .5 hr = end_time +.5/24
When start and end time are entered in sexagesimal format
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
|