Slight correction:

7:15 AM 9:15 AM 2:30 PM 7:15 PM
--0.75----1.25----3.5-----1.25


B15 =IF(B14<TIME(8,0,0),(TIME(8,0,0)-B14)*24)
C15 =(C14-TIME(8,0,0))*24
D15 =IF(E14TIME(18,0,0),(TIME(18,0,0)-D14)*24)
E15 =(E14-TIME(18,0,0))*24


--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"JBeaucaire" wrote:


Logically, that didn't all flow, so this is what I discerned, you wanted
specific decimal time values below the time stamps themselves. The first
two breaking out around 8am, the second two breaking out around 6pm.

If so, here are the formulas:

B15 =IF(B14<TIME(8,0,0),(TIME(8,0,0)-B14)*24)
C15 =(TIME(8,0,0)-C14)*-24
D15 =IF(E14TIME(18,0,0),(TIME(18,0,0)-D14)*24)
E15 =(TIME(18,0,0)-E14)*-24


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=59502