Thread: [Solved] Formula help request
View Single Post
 
Old 03-30-2012, 12:42 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,599
Pecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to beholdPecoflyer is a splendid one to behold
Default

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
Reply With Quote