Thread: how do I calculate minutes when given two times?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mallycat
 
Posts: n/a
Default how do I calculate minutes when given two times?

Try this

Enter 8:30 in cell a1
enter 14:45 in cell a2
The elapsed time in minutes is =HOUR(A2-A1)*60+MINUTE(A2-A1)

Matt


--
Mallycat
------------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...o&userid=35514
View this thread: http://www.excelforum.com/showthread...hreadid=552876

Reply With QuoteReply With Quote