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