Hour formula

[VBABEGINER]

[TABLE="width: 538"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Shift Start Time (24 hour format[/TD]
[TD]Shift End Time (24 hour format)[/TD]
[TD]Process SLA (hours)[/TD]
[/TR]
[TR]
[TD]13:30[/TD]
[TD]22:30[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]22:30[/TD]
[TD]7:30[/TD]
[TD]-15[/TD]
[/TR]
</tbody>[/TABLE]

Formula Used in "Process SLA (hours)"

=HOUR(B3)-HOUR(A3)

-15 is the wrong answer. How will I get correct Hours (positive number)

 

[Joe4]

Try:

=IF(HOUR(B3)>HOUR(A3),HOUR(B3)-HOUR(A3),HOUR(B3)-HOUR(A3)+24)

 

[VBABEGINER]

Super..

Try:

=IF(HOUR(B3)>HOUR(A3),HOUR(B3)-HOUR(A3),HOUR(B3)-HOUR(A3)+24)

 

[Marcelo Branco]

Or

=MOD(B3-A3,1)*24

M.

 

[snjpverma]

or

=HOUR(B2-A2+1)