Formulaes

Hi Paul

Thanks for getting in touch.

It does work easier with the date so it can understand the where the times are in relation to each other. If this isn't an option, use an IF function to bump up the time and decide which way round to subtract. Assuming start time is in A1 and end time is in B1:

=if(A1>B1,B1+1-A1,B1-A1)

To read more, there's a detailed explanation of all your possible time calculations on Microsoft's site:

http://office.microsoft.com/en-us/excel-help/add-or-subtract-time-HA102809662.aspx

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector