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





"FC" wrote in message
...
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.

Thanks a lot, appreciate it.

"Peo Sjoblom" wrote:

=(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





"FC" wrote in message
...
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.

Assuming cells A1 and B1 contain only times (no dates) put this formula in
C1 =(IF(B1<A1,B1+1,B1)-A1)*24*60

"FC" wrote in message
...
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.

Formula assumes A1 is start time and B1 is end time

"Wondering" wrote in message
et...
Assuming cells A1 and B1 contain only times (no dates) put this formula in
C1 =(IF(B1<A1,B1+1,B1)-A1)*24*60

"FC" wrote in message
...
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.

THANKS

"Wondering" wrote:

Assuming cells A1 and B1 contain only times (no dates) put this formula in
C1 =(IF(B1<A1,B1+1,B1)-A1)*24*60

"FC" wrote in message
...
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.

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





"Wondering" wrote in message
et...
Assuming cells A1 and B1 contain only times (no dates) put this formula in
C1 =(IF(B1<A1,B1+1,B1)-A1)*24*60

"FC" wrote in message
...
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.

Just using John Walkenbach's formula

"Peo Sjoblom" wrote in message
...
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





"Wondering" wrote in message
et...
Assuming cells A1 and B1 contain only times (no dates) put this formula
in C1 =(IF(B1<A1,B1+1,B1)-A1)*24*60

"FC" wrote in message
...
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.