I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?

Hi,
See CPearson web has the solution you are looking for with examples

http://www.cpearson.com/excel/DateTimeWS.htm

if this helps please click yes, thanks

"Brownie_D75" wrote:

I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?

If your date/time values are in one cell (each) as real Excel date and
times, then...

=24*(B1-A1)

assuming your later date time value is in B1 and your earlier one is in A1.

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?

This is where it get a little complicated. The hour the truck arrived is in
military (24:00) in one cell. Then the date is in another. I have to manually
enter the current date & 05:30. I need to calculate those total hours (hours
& minutes are ok too). When I calulated it with the below formula, it only
came up with 13:36. (Truck arrived at 24:56 on 7/28/09. As of 05:30 on
7/30/09 = ??? hours?

"Rick Rothstein" wrote:

If your date/time values are in one cell (each) as real Excel date and
times, then...

=24*(B1-A1)

assuming your later date time value is in B1 and your earlier one is in A1.

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?

A.Date = Arrived Date
AODate = As of Date

ColA ColB ColC ColD ColE
A.Date A.Time AODate AOTime Total Hours
7/28/2009 23:56 7/29/2009 5:30 5:34

Total hours in cell E2
=(C2+D2)-(A2+B2)
and custom format the total cell as below..
[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"Brownie_D75" wrote:

This is where it get a little complicated. The hour the truck arrived is in
military (24:00) in one cell. Then the date is in another. I have to manually
enter the current date & 05:30. I need to calculate those total hours (hours
& minutes are ok too). When I calulated it with the below formula, it only
came up with 13:36. (Truck arrived at 24:56 on 7/28/09. As of 05:30 on
7/30/09 = ??? hours?

"Rick Rothstein" wrote:

If your date/time values are in one cell (each) as real Excel date and
times, then...

=24*(B1-A1)

assuming your later date time value is in B1 and your earlier one is in A1.

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?

I think this formula is missing something. If I put in my data for this
formula, it come up to 4:34. My data says arrival date is 7/28 at midnight &
then date I want the information for is 7/30 at 05:30. There is more than 4
1/2 hours between 7/28 & 7/30.

"Jacob Skaria" wrote:

A.Date = Arrived Date
AODate = As of Date

ColA ColB ColC ColD ColE
A.Date A.Time AODate AOTime Total Hours
7/28/2009 23:56 7/29/2009 5:30 5:34

Total hours in cell E2
=(C2+D2)-(A2+B2)
and custom format the total cell as below..
[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"Brownie_D75" wrote:

This is where it get a little complicated. The hour the truck arrived is in
military (24:00) in one cell. Then the date is in another. I have to manually
enter the current date & 05:30. I need to calculate those total hours (hours
& minutes are ok too). When I calulated it with the below formula, it only
came up with 13:36. (Truck arrived at 24:56 on 7/28/09. As of 05:30 on
7/30/09 = ??? hours?

"Rick Rothstein" wrote:

If your date/time values are in one cell (each) as real Excel date and
times, then...

=24*(B1-A1)

assuming your later date time value is in B1 and your earlier one is in A1.

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?

Did you custom format the total cell as [h]:mm

Right clickFormatCellsCustomType:=
[h]:mm

--
If this post helps click Yes
---------------
Jacob Skaria


"Brownie_D75" wrote:

I think this formula is missing something. If I put in my data for this
formula, it come up to 4:34. My data says arrival date is 7/28 at midnight &
then date I want the information for is 7/30 at 05:30. There is more than 4
1/2 hours between 7/28 & 7/30.

"Jacob Skaria" wrote:

A.Date = Arrived Date
AODate = As of Date

ColA ColB ColC ColD ColE
A.Date A.Time AODate AOTime Total Hours
7/28/2009 23:56 7/29/2009 5:30 5:34

Total hours in cell E2
=(C2+D2)-(A2+B2)
and custom format the total cell as below..
[h]:mm

If this post helps click Yes
---------------
Jacob Skaria


"Brownie_D75" wrote:

This is where it get a little complicated. The hour the truck arrived is in
military (24:00) in one cell. Then the date is in another. I have to manually
enter the current date & 05:30. I need to calculate those total hours (hours
& minutes are ok too). When I calulated it with the below formula, it only
came up with 13:36. (Truck arrived at 24:56 on 7/28/09. As of 05:30 on
7/30/09 = ??? hours?

"Rick Rothstein" wrote:

If your date/time values are in one cell (each) as real Excel date and
times, then...

=24*(B1-A1)

assuming your later date time value is in B1 and your earlier one is in A1.

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30, how
many hours has that truck been here?

It is always a good idea to show us an example of your layout. Assuming your
start date and time are in A1 and B1 and your end date and time are in C1
and D1...

=24*((C1+D1)-(A1+B1))

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
This is where it get a little complicated. The hour the truck arrived is
in
military (24:00) in one cell. Then the date is in another. I have to
manually
enter the current date & 05:30. I need to calculate those total hours
(hours
& minutes are ok too). When I calulated it with the below formula, it only
came up with 13:36. (Truck arrived at 24:56 on 7/28/09. As of 05:30 on
7/30/09 = ??? hours?

"Rick Rothstein" wrote:

If your date/time values are in one cell (each) as real Excel date and
times, then...

=24*(B1-A1)

assuming your later date time value is in B1 and your earlier one is in
A1.

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30,
how
many hours has that truck been here?

Date Received Time Received Current Date Time
7/28/09 22:30 7/30/09 05:30 =
31 hours


"Rick Rothstein" wrote:

It is always a good idea to show us an example of your layout. Assuming your
start date and time are in A1 and B1 and your end date and time are in C1
and D1...

=24*((C1+D1)-(A1+B1))

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
This is where it get a little complicated. The hour the truck arrived is
in
military (24:00) in one cell. Then the date is in another. I have to
manually
enter the current date & 05:30. I need to calculate those total hours
(hours
& minutes are ok too). When I calulated it with the below formula, it only
came up with 13:36. (Truck arrived at 24:56 on 7/28/09. As of 05:30 on
7/30/09 = ??? hours?

"Rick Rothstein" wrote:

If your date/time values are in one cell (each) as real Excel date and
times, then...

=24*(B1-A1)

assuming your later date time value is in B1 and your earlier one is in
A1.

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30,
how
many hours has that truck been here?

I understood the headings... I was referring to the column letters and
starting row number. Still assuming we are talking about columns A thru D,
did you try my latest posted formula (after adjusting the row number)?
Assuming the columns as stated and the starting row as 2, that formula is...

=24*((C2+D2)-(A2+B2))

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
Date Received Time Received Current Date Time
7/28/09 22:30 7/30/09 05:30 =
31 hours


"Rick Rothstein" wrote:

It is always a good idea to show us an example of your layout. Assuming
your
start date and time are in A1 and B1 and your end date and time are in C1
and D1...

=24*((C1+D1)-(A1+B1))

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
This is where it get a little complicated. The hour the truck arrived
is
in
military (24:00) in one cell. Then the date is in another. I have to
manually
enter the current date & 05:30. I need to calculate those total hours
(hours
& minutes are ok too). When I calulated it with the below formula, it
only
came up with 13:36. (Truck arrived at 24:56 on 7/28/09. As of 05:30 on
7/30/09 = ??? hours?

"Rick Rothstein" wrote:

If your date/time values are in one cell (each) as real Excel date and
times, then...

=24*(B1-A1)

assuming your later date time value is in B1 and your earlier one is
in
A1.

--
Rick (MVP - Excel)


"Brownie_D75" wrote in message
...
I need a formula to shows hours between dates.

Example:
Truck arrived @ 22:00. It arrived on 7/28/09. As of 7/30/09 @ 05:30,
how
many hours has that truck been here?