formula to get the HOURS from 2 dates with time

**albert28** · 06-30-2014, 11:03 PM

Hi guys,

Anyone here know how to get the Hours of two different time

A1
27/06/2014 11:30

B1
30/06/2014 18:14

C1

Ans: Hours of these 2 dates with time.

i just need to get their HOurs.

thanks alot

**MarvinP** · 06-30-2014, 11:24 PM

Hi albert,

I think the Hour() function will return the hour, even it there is a date included in the number.

See http://www.excelfunctions.net/Excel-Hour-Function.html

**dubcap01** · 07-01-2014, 03:25 AM

Hi Albert28,

If you are looking for the hours elapsed between those two dates and times then the formula in C1 is =INT((B1-A1)*24) ( 78 )
If you want to extract the 11 from 11:30 then MarvinP's answer is the way to go: cell C1 =HOUR(A1) cell D1 =HOUR(B1)

If you require something different, try uploading a sample spreadsheet

regards
Pete

**goligoli100** · 08-01-2014, 02:35 PM

Hi Guys,
Have been browsing thru the threads. Many ideas to read from and much to learn. Thanks a lot for the stuff. Much appreciated.

Kind regards to all the team.