Calculate hours between to separate dates and times


D

Dave08

I need to work out the amount of hours between a finish time on one day and
the start time on the next day. In some cases the start time may not be until
2 days time.
 
Ad

Advertisements

B

Bob Phillips

Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you
want the mins as well)
 
D

Dave08

Thanks Bob, But the problem is the times are on 2 separate dates e.g. finish
2/10/2008 0200 and start 3/10/2008 12.00

Bob Phillips said:
Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you
want the mins as well)
--
__________________________________
HTH

Bob

Dave08 said:
I need to work out the amount of hours between a finish time on one day and
the start time on the next day. In some cases the start time may not be
until
2 days time.
 
B

Bernard Liengme

Since Excel stored dates as serial numbers, try =(A2-a1)*24 where 24
converts fractions of a day to hours
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

Dave08 said:
Thanks Bob, But the problem is the times are on 2 separate dates e.g.
finish
2/10/2008 0200 and start 3/10/2008 12.00

Bob Phillips said:
Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you
want the mins as well)
--
__________________________________
HTH

Bob

Dave08 said:
I need to work out the amount of hours between a finish time on one day
and
the start time on the next day. In some cases the start time may not be
until
2 days time.
 
F

FC

Still with differente dates the given formula applies :
Format the 2 dates cells as : 3/14/01 1:30PM
and the 3er date cell(result) as : [h]:mm:ss.
If you mean different worksheets, then just
right the worksheet name in form of the cell as
ex: =A1-SHEET3!A2

Dave08 said:
Thanks Bob, But the problem is the times are on 2 separate dates e.g. finish
2/10/2008 0200 and start 3/10/2008 12.00

Bob Phillips said:
Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you
want the mins as well)
--
__________________________________
HTH

Bob

Dave08 said:
I need to work out the amount of hours between a finish time on one day and
the start time on the next day. In some cases the start time may not be
until
2 days time.
 
B

Bob Phillips

That doesn't impact my response one iota. Try it!

--
__________________________________
HTH

Bob

Dave08 said:
Thanks Bob, But the problem is the times are on 2 separate dates e.g.
finish
2/10/2008 0200 and start 3/10/2008 12.00

Bob Phillips said:
Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you
want the mins as well)
--
__________________________________
HTH

Bob

Dave08 said:
I need to work out the amount of hours between a finish time on one day
and
the start time on the next day. In some cases the start time may not be
until
2 days time.
 
Ad

Advertisements

D

Dave08

I found this option worked the best in resolving my delima. because I had the
finish and start dates and times in seperate coloums I had to first calculate
them then subtract them. I then formatted them [hh]:mm
Date in Column A and the times in Columns B
=(A2+B2)-(A1+B1)


Bob Phillips said:
That doesn't impact my response one iota. Try it!

--
__________________________________
HTH

Bob

Dave08 said:
Thanks Bob, But the problem is the times are on 2 separate dates e.g.
finish
2/10/2008 0200 and start 3/10/2008 12.00

Bob Phillips said:
Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if you
want the mins as well)
--
__________________________________
HTH

Bob

I need to work out the amount of hours between a finish time on one day
and
the start time on the next day. In some cases the start time may not be
until
2 days time.
 
Ad

Advertisements

B

Bob Phillips

It does help if you give all the information at the start. You never
mentioned the separate cells.

--
__________________________________
HTH

Bob

Dave08 said:
I found this option worked the best in resolving my delima. because I had
the
finish and start dates and times in seperate coloums I had to first
calculate
them then subtract them. I then formatted them [hh]:mm
Date in Column A and the times in Columns B
=(A2+B2)-(A1+B1)


Bob Phillips said:
That doesn't impact my response one iota. Try it!

--
__________________________________
HTH

Bob

Dave08 said:
Thanks Bob, But the problem is the times are on 2 separate dates e.g.
finish
2/10/2008 0200 and start 3/10/2008 12.00

:

Just subtract them, =A2-A1, and format the cell as [h] (or [h]:mm if
you
want the mins as well)
--
__________________________________
HTH

Bob

I need to work out the amount of hours between a finish time on one
day
and
the start time on the next day. In some cases the start time may not
be
until
2 days time.
 

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

Top