Formula to subtract time

[Steved]

Hello from Steved

Could I please have a formula for the below it should add
up to 26:45 but I am getting 1682:45 each sum=8:55
3:00 p.m. 12:25 a.m. -0:30
3:00 p.m. 12:25 a.m. -0:30
3:00 p.m. 12:25 a.m. -0:30

 

[JE McGimpsey]

Not sure exactly what's going on, but you appear to have your cell
formatted as

[mm]:ss

rather than

[hh]:mm

When I use the latter format, with the time data in A1:B3,

=SUMPRODUCT(MOD(B1:B3-A1:A3,1))-3*TIME(0,30,0)

returns 26:45.

 

[Steved]

Thankyou JE

-----Original Message-----
Not sure exactly what's going on, but you appear to have your cell
formatted as

[mm]:ss

rather than

[hh]:mm

When I use the latter format, with the time data in A1:B3,

=SUMPRODUCT(MOD(B1:B3-A1:A3,1))-3*TIME(0,30,0)

returns 26:45.

Hello from Steved

Could I please have a formula for the below it should add
up to 26:45 but I am getting 1682:45 each sum=8:55
3:00 p.m. 12:25 a.m. -0:30
3:00 p.m. 12:25 a.m. -0:30
3:00 p.m. 12:25 a.m. -0:30

.