how do i find # hrs & mins. between 2 different dates and times

T

tankerman

In excel I have to keep start and finish times for different product
movements, I am constantly figuring the # of hours and mins. EXAMPLE start
date 8/12/2005 time 13:15, finish date 8/13/2005 time 05:35 equals 16 hrs and
20 minutes. Can excel figure this for me or am I out of luck.
 
I

Ian

Enter the date and time data in one cell as eg 8/12/2005 13:15 then subtract
one from the other. Format the cell as hh:mm
 
K

KL

if
[A1]='8/12/2005 13:15'
and
[B1]='8/13/2005 05:35'
then
[C1]=B1-A1

and format [C1] as absolute time - menu: Format>Cell..., tab: Number,
category: Custom, type: [h]:mm

Regards,
KL
 
R

Ron Rosenfeld

In excel I have to keep start and finish times for different product
movements, I am constantly figuring the # of hours and mins. EXAMPLE start
date 8/12/2005 time 13:15, finish date 8/13/2005 time 05:35 equals 16 hrs and
20 minutes. Can excel figure this for me or am I out of luck.
Click to expand...


A1: 8/12/2005 13:15
A2: 8/13/2005 05:35

A3: =A2-A1
Format/Cells/Number/Custom Type: [h]:mm

Note the brackets around the 'h'. This allows display of hours > 24.


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem formatting dates from CSV file 2
Calculating the difference, in hours, between two date/time in two different time zon 2
HOURS DIFFERENCE IN TIME BETWEEN DIFFERENT DATES AND TIMES 1
Macro / function text time to 24hr excel time passed midnight fortotaling hr's 2
TimeSheet Using 100 Minutes & Rounding to .25 2
How do I combine 2 data sets using date? 2
Date Time increment with additional condition of skipping weekends 18
Sum Time 7

Top