Formula to subtract time

  • Thread starter Thread starter Steved
  • Start date Start date
S

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
 
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.
 
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.


Steved said:
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
Click to expand...
.
Click to expand...
 
Back
Top