Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Difference between times (Answer in minutes)

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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
CALCULATE DIFFERENCE BETWEEN 2 TIMES - RESULT IN MINUTES CB Excel Discussion (Misc queries) 3 May 21st 07 09:59 PM
Date Difference in ONLY minutes [email protected] Excel Discussion (Misc queries) 1 May 20th 07 07:28 PM
Subtract one time from another and get answer in minutes Zoombini Excel Discussion (Misc queries) 3 April 22nd 05 12:56 AM
Calculate the time difference in minutes Benjamin Davis Excel Programming 3 September 24th 04 05:27 AM
minutes between two times Steve[_42_] Excel Programming 3 May 16th 04 02:35 AM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"