LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Calculate the time difference in minutes

I want to be able to enter a start time in cell A1 finish time in B1 and
in C1 have the difference in minutes displayed. So far I have this
PLAN ACTUAL Start Time Finish Time
MINUTES MINUTES
12:00 20:00 1:15 1:35

50.28 71:00 1:35 2:46

42.81 39:00 2:46 3:25

11.48 13:00 3:25 3:38

19.80 22:00 3:38 4:00

136.67 165:00

I have plan time for the job in cell A1 The actual time is a subtraction
resulting from the start time in C1 being subtracted from the finish
time in D1. My problem is if I enter times in the AM or PM say 1300
start and 1345 finish it should tell me 45 minutes have elapsed or all
hours should be converted to minutes such as 1 hour 10 minutes would be
70 minutes.

Is this possible?

 
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
to calculate the difference between sign in and signout time in minutes. [email protected] Excel Worksheet Functions 5 October 1st 06 04:55 PM
Difference of time in hours or minutes Charles Excel Discussion (Misc queries) 2 September 13th 06 11:12 PM
Calculating time difference in minutes jonhunt Excel Worksheet Functions 7 July 3rd 06 03:49 PM
Difference of date & time in minutes ramsdesk Excel Worksheet Functions 2 November 10th 04 06:01 AM


All times are GMT +1. The time now is 02:07 AM.

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"