Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CALCULATE DIFFERENCE BETWEEN 2 TIMES - RESULT IN MINUTES | Excel Discussion (Misc queries) | |||
to calculate the difference between sign in and signout time in minutes. | Excel Worksheet Functions | |||
Difference of time in hours or minutes | Excel Discussion (Misc queries) | |||
Calculating time difference in minutes | Excel Worksheet Functions | |||
Difference of date & time in minutes | Excel Worksheet Functions |