| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compute time differences
What formula will compute the number of hours and minutes between the Start Time and the End time in each row?
(Each cell is formatted as number, custom, type: h:mm AM/PM) Start time End time 12:45 PM 3:14 PM 10:20 AM 12:10 PM 10:20 AM 12:30 PM 9:30 AM 11:30 AM 10:00 AM 12:24 PM 11:20 AM 1:40 PM 11:27 AM 1:42 PM 1:35 PM 3:51 PM 10:30 AM 12:38 PM 11:55 AM 2:05 PM 10:05 AM 12:00 PM 12:00 PM 2:10 PM 10:00 AM 12:50 PM 11:55 AM 1:40 PM 12:45 PM 2:58 PM 12:45 PM 3:13 PM |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compute time differences
GARYWC wrote:
What formula will compute the number of hours and minutes between the Start Time and the End time in each row? (Each cell is formatted as number, custom, type: h:mm AM/PM) Just "=B2-A2" and format the destination cells as time without AM/PM. -- Kneel! Bow! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compute time differences
GARYWC wrote:
What formula will compute the number of hours and minutes between the Start Time and the End time in each row? (Each cell is formatted as number, custom, type: h:mm AM/PM) Just "=B2-A2" and format the destination cells as time without AM/PM. That only works so long as the time values aren't PM start to AM End. -- Garry Free usenet access at http://www.eternal-september.org Classic VB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compute time differences
In reply to "GARYWC" who wrote the following:
What formula will compute the number of hours and minutes between the Start Time and the End time in each row? (Each cell is formatted as number, custom, type: h:mm AM/PM) Use formule(A2B2)+B2-A1) Cel set hh:mm Use no PM/AM but 24 hours Regards -- --------------------------------- --- -- - Posted with NewsLeecher v7.0 Beta 10 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Compute time differences
What formula will compute the number of hours and minutes between the Start Time and the End time in each row? (Each cell is formatted as number, custom, type: h:mm AM/PM) Excuse for mistyping in the first respose. Use formule(A2B2)+B2-A2 Cel set hh:mm Use no PM/AM but 24 hours Regards -- --------------------------------- --- -- - Posted with NewsLeecher v7.0 Beta 10 Web @ http://www.newsleecher.com/?usenet ------------------- ----- ---- -- - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Time Sheet - Calculating Time Differences for Totals | Excel Discussion (Misc queries) | |||
| compute date and time difference | Excel Worksheet Functions | |||
| Very long workbook computation time (F9 manual compute) | Excel Discussion (Misc queries) | |||
| what if problem to compute cost depending on time | Excel Discussion (Misc queries) | |||
| Macros to compute Sales figures Differences between Months | Excel Programming | |||
Hybrid Mode
