Calculating time, but need the cell to remain blank if no times entered

[Tazzbjs]

Ok, I know this should be an easy fix. I am calculating volunteer hours to total in cell H2, but I want H2 to stay blank if there are no times entered in Cells F2 or G2. Thank-you in advance for your help.

 

[kevin9999]

Do you mean like this?

Book1
	F	G	H
1	Time in	Time out	Total
2	6:38 AM	12:30 PM	5.87
3	7:30 AM
4		1:00 PM
5
6	5:00 AM	12:45 PM	7.75
Sheet1

Cell Formulas
Range	Formula
H2:H6	H2	=IF(OR(F2="",G2=""),"",((G2-F2)*24))

 

[Tazzbjs]

Do you mean like this?

Book1
	F	G	H
1	Time in	Time out	Total
2	6:38 AM	12:30 PM	5.87
3	7:30 AM
4		1:00 PM
5
6	5:00 AM	12:45 PM	7.75
Sheet1

Cell Formulas
Range	Formula
H2:H6	H2	=IF(OR(F2="",G2=""),"",((G2-F2)*24))

Exactly what I was looking for! Thank-you for your help.

 

[kevin9999]

Happy to help, and thanks for the feedback