Finding range between start times, spanning across midnight

Tony,

Thanks for your response.

We can't include the date, because the start times are manually keyed in to a spreadsheet.

kashflo

By range of movement do you mean the number of hours between 2 times. If it is the case try the following :

= MOD(END_TIME - START_TIME,1)

It will take care the midnight span ... if you want it in terms of number of hours multiply the above by 24 or utilize the

HOUR()

function:

= MOD(END_TIME - START_TIME,1)*24

= HOUR(MOD(END_TIME - START_TIME,1))

Hope that helps