suming time into minutes

[Fyr]

I want to =sum time from two time formart values.
Example: 7:30 - 11:30 = 4:00
but I want it to be like this: 7:30 - 11:30 = 240 minutes.

thanks for taking a look!

 

[c_m]

Try
=HOUR(B1-A1)*60+MINUTE(B1-A1)
where A1 = 7:30 and B1 = 11:30
and format the cell to general.

 

[barry houdini]

If start time is in A1 and end time in B1 try

=MOD(B1-A1,1)*1440

 

[Fyr]

thanks that worked!!

 

[c_m]

If start time is in A1 and end time in B1 try

=MOD(B1-A1,1)*1440

what is the purpose of MOD for this?
=(B1-A1)*1440
works too.

 

[Scott Huish]

what is the purpose of MOD for this?
=(B1-A1)*1440
works too.

not if your times cross midnight. That's why MOD is used in the formula.

 

[c_m]

not if your times cross midnight. That's why MOD is used in the formula.

Thankyou