Thread: ADDING MINUTES
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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.