Thread: ADDING MINUTES
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
FC FC is offline
external usenet poster
 
Posts: 130
Default ADDING MINUTES

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.