Thread: ADDING MINUTES
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Wondering[_2_] Wondering[_2_] is offline
external usenet poster
 
Posts: 75
Default ADDING MINUTES - addendum

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.