Time Calculation having negative value

[Rhon Alvarez]

Hi Team,

would like to seek assistance in proper computation of time to avoid having negative value when the time factor includes change in date.

please see attached file and screenshot below.

thanks in advance.

 

[AliGW]

In E2 copied down:

=IF(C2>D2,((1-C2)+D2)*24,(D2-C2)*24)

 

[p45cal]

Also

=(D2-C2+(D2<C2))*24

 

[Rhon Alvarez]

In E2 copied down:

=IF(C2>D2,((1-C2)+D2)*24,(D2-C2)*24)

Thanks @AliGW

this is awesome!

 

[Rhon Alvarez]

Also

=(D2-C2+(D2<C2))*24

thanks @p45cal

a much concise formula

 

[AliGW]

Glad to help.