View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
 
Posts: 15,768
Default Hours to Minutes Formula

Try this:

=MOD(B1-A1,1)*1440

Format as General or Number

--
Biff
Microsoft Excel MVP


"Ana24" wrote in message
...
Is there a formula to calculate minutes? For example: Colum A: 7:00 Colum
B:
8:30... I want Column C to say 90 for minutes instead of 1:30 for
1hr30min,
which is what I currently have. Thanks!