View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Difference between times (Answer in minutes)

Try

=B1-A1

use a custom Format of [mm]

Mike

"Difference between times (Answer in minu" wrote:

The problem is following
Cell A1 time is 00:00 and Cell B1 time is 01:10
I want the result in minutes the answer is 70 min. how can I calculate it.
Please help me and guide me with formula.
My email address is

ThankYou
Adil Farhan