ADDING MINUTES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

With a stating time in A and finish time in B , I need a formula to add the
total minutes used to put it in C.
A B C

1 8:15 9:00 Formula

C1 will be 45 in minutes please. Thanks for the help.
 
=(B1-A1)*24*60

FORMAT C1 as General or number, NOT time

if the time can start before midnight and end after you can use


=MOD(B1-A1,1)*24*60


--


Regards,


Peo Sjoblom
 
Thanks a lot, appreciate it.

Peo Sjoblom said:
=(B1-A1)*24*60

FORMAT C1 as General or number, NOT time

if the time can start before midnight and end after you can use


=MOD(B1-A1,1)*24*60


--


Regards,


Peo Sjoblom
Click to expand...
 
Assuming cells A1 and B1 contain only times (no dates) put this formula in
C1 =(IF(B1<A1,B1+1,B1)-A1)*24*60
 
No need to use IF in this case since a Boolean value used in a calculation
defaults to either 1 or 0

=(B1-A1+(B1<A1))*24*60

will suffice


--

Regards,

Peo Sjoblom
 
Just using John Walkenbach's formula

Peo Sjoblom said:
No need to use IF in this case since a Boolean value used in a calculation
defaults to either 1 or 0

=(B1-A1+(B1<A1))*24*60

will suffice


--

Regards,

Peo Sjoblom
Click to expand...
 
Back
Top