Calculate only number of hours between two date & time

[Tapas Kumar Ratha]

GOOD AFTERNOON TO EVERYONE. I HAVE A NEW EXCEL QUESTION REGARDING CALCULATION OF ONLY HOURS BETWEEN TWO DATE & TIME.

REPORTING DATE	REPORTING TIME	RELEASING DATE	RELEASING TIME	COUNT OF HOURS	FORMULA
20-02-22	10:00 AM	21-02-22	12:00 PM	26 HOUR

 

[arthurbr]

try

=(A3+A4-A1-A2)*24

 

[SanjayGMusafir]

Try this and revert -

Book1
	A	B	C	D	E	F
2	REPORTING DATE	REPORTING TIME	RELEASING DATE	RELEASING TIME	COUNT OF HOURS	FORMULA
3	2/20/22	10:00 AM	2/21/22	12:00 PM	26 HOUR	26.00
Sheet1

Cell Formulas
Range	Formula
F3	F3	=IF(C3+D3-A3-B3>1,(C3+D3-A3-B3),MOD(C3+D3-A3-B3,1))*24

 

[Tapas Kumar Ratha]

try

=(A3+A4-A1-A2)*24

Thank you very much for solving my excel question.

 

[Tapas Kumar Ratha]

Try this and revert -

Book1
	A	B	C	D	E	F
2	REPORTING DATE	REPORTING TIME	RELEASING DATE	RELEASING TIME	COUNT OF HOURS	FORMULA
3	2/20/22	10:00 AM	2/21/22	12:00 PM	26 HOUR	26.00
Sheet1

Cell Formulas
Range	Formula
F3	F3	=IF(C3+D3-A3-B3>1,(C3+D3-A3-B3),MOD(C3+D3-A3-B3,1))*24

Thank you Sanjay Sir for giving this solution.

 

[SanjayGMusafir]

Glad to help you and thanks for the feedback.

It is always appreciated to mark the post as solution which worked for you... It helps other people to get a quick reference.