# Calculating between dates and times

• I need to be able to calculate the length of time (in hours) between two times and dates.

I have four cells, one each for start date and start time as well as end date and end time. Is there an easy way of doing this?

I can work out the number of full days between the dates using =DAYS360 and multiplying it by 24 and get the times by subtracting them to find the hours. But the problem is when it is less than 24 hours.

I know there is a way to do this but my mind has gone blank. Any help would be greatly appreciated.

• Re: Calculating between dates and times

Personally i'd use DATEDIF over days360

See attached EG

## Files

Kind Regards, Will Riley

• Re: Calculating between dates and times

Hi

See if you can use this one.

This one counts the dates and the hours. But the result comes as dates:hours:minutes.

alring

## Files

• Re: Calculating between dates and times

Thanks alring thats great

• Re: Calculating between dates and times

Surely simply combining the date/times for start and end, and then subtracting ( formatted as [HH]:MM ) will do this?

Code
``=(C1+D1)-(A1+B1)``

Cheers, Glenn.

Beauty is in the eye of the beer-holder.

• Re: Calculating between dates and times

=((C1+D1)-(A1+B1))*24
where
C1 = end date
D1 = end time
A1 = start date
B1 = start time

format the result as general

In formulae, depending on your locale, you might have to replace ; with , or vice versa.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!