Paul has attended:
Excel Intermediate course
Access Introduction course
Formulaes
how is it possible to to take one hour from another hour without putting the date in .
I can do 16:00 from 23:00 .
i want to be able to do 16:00 from 01.30 the next day
please
RE: 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
