Hours between dates
 

Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records which
give you an answer of 12.00 that would be 1 day. I think once I get this
formula fixed I hope I can get the other by selecting all the records and
divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

hi
i think days360 counts days not hours. if your times are that close, you
might be better off just subtracting H2 from G2 and formating the results as
time ie [hh]:mm:ss. the brackets around the hh will cause the hours to
accumilate and not roll over every 24 hours.

Regards
FSt1

"Linda RQ" wrote:

Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records which
give you an answer of 12.00 that would be 1 day. I think once I get this
formula fixed I hope I can get the other by selecting all the records and
divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

=B1-A1 and format as [h]:mm

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I get
this formula fixed I hope I can get the other by selecting all the records
and divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

If you need the actual decimal hours (13.666...), then try this formula...

=24*(H2-G2)

--
Rick (MVP - Excel)


"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I get
this formula fixed I hope I can get the other by selecting all the records
and divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

You Da Man Rick! Thanks!


"Rick Rothstein" wrote in message
...
If you need the actual decimal hours (13.666...), then try this formula...

=24*(H2-G2)

--
Rick (MVP - Excel)


"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I
get this formula fixed I hope I can get the other by selecting all the
records and divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

Thanks Bob, I tried to put formatting in but I kept getting an error because
I really don't know where to put the parentheses so I tried Rick's solution
and it worked!


"Bob Phillips" wrote in message
...
=B1-A1 and format as [h]:mm

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I
get this formula fixed I hope I can get the other by selecting all the
records and divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

Thanks FSt1, I couldn't figure out how to put the formatting into the
formula/fx


Linda

"FSt1" wrote in message
...
hi
i think days360 counts days not hours. if your times are that close, you
might be better off just subtracting H2 from G2 and formating the results
as
time ie [hh]:mm:ss. the brackets around the hh will cause the hours to
accumilate and not roll over every 24 hours.

Regards
FSt1

"Linda RQ" wrote:

Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which
give you an answer of 12.00 that would be 1 day. I think once I get this
formula fixed I hope I can get the other by selecting all the records and
divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

hi
don't put the fomating in the formula.
right click the desired cell, choose format cell.
click the number tab. click custom. enter the custom format there.
once entered, you can format other cells by selecting the custom format
Regards
FSt1

"Linda RQ" wrote:

Thanks FSt1, I couldn't figure out how to put the formatting into the
formula/fx


Linda

"FSt1" wrote in message
...
hi
i think days360 counts days not hours. if your times are that close, you
might be better off just subtracting H2 from G2 and formating the results
as
time ie [hh]:mm:ss. the brackets around the hh will cause the hours to
accumilate and not roll over every 24 hours.

Regards
FSt1

"Linda RQ" wrote:

Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which
give you an answer of 12.00 that would be 1 day. I think once I get this
formula fixed I hope I can get the other by selecting all the records and
divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Thanks Bob, I tried to put formatting in but I kept getting an error
because I really don't know where to put the parentheses so I tried Rick's
solution and it worked!


"Bob Phillips" wrote in message
...
=B1-A1 and format as [h]:mm

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I
get this formula fixed I hope I can get the other by selecting all the
records and divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

So it would be =B1-A1[h]:mm


"Bob Phillips" wrote in message
...
It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Thanks Bob, I tried to put formatting in but I kept getting an error
because I really don't know where to put the parentheses so I tried
Rick's solution and it worked!


"Bob Phillips" wrote in message
...
=B1-A1 and format as [h]:mm

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I
get this formula fixed I hope I can get the other by selecting all the
records and divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

You left out the "and format as" part...

=B1-A1 and format as [h]:mm

--
Rick (MVP - Excel)


"Linda RQ" wrote in message
...
So it would be =B1-A1[h]:mm


"Bob Phillips" wrote in message
...
It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Thanks Bob, I tried to put formatting in but I kept getting an error
because I really don't know where to put the parentheses so I tried
Rick's solution and it worked!


"Bob Phillips" wrote in message
...
=B1-A1 and format as [h]:mm

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I
get this formula fixed I hope I can get the other by selecting all the
records and divide by 24 to get my total days?

Thanks,
Linda

Hours between dates
 

No it would be

=B1-A1

as the formula in the cell, then select menu FormatCellsCustom and enter
[h]:mm in the inputbox.

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
So it would be =B1-A1[h]:mm


"Bob Phillips" wrote in message
...
It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Thanks Bob, I tried to put formatting in but I kept getting an error
because I really don't know where to put the parentheses so I tried
Rick's solution and it worked!


"Bob Phillips" wrote in message
...
=B1-A1 and format as [h]:mm

--
__________________________________
HTH

Bob

"Linda RQ" wrote in message
...
Hi Everyone,

I have been playing around and can't quite get it.

I have 2 columns Start Date and Time and End Date and Time

I tried this function =DAYS360(G2,H2)

4/5/07 4:12am
4/5/07 5:34 pm

Gives me 0.00 for an answer. I need the hours

The ultimate goal is to calculate total days which if I have 2 records
which give you an answer of 12.00 that would be 1 day. I think once I
get this formula fixed I hope I can get the other by selecting all the
records and divide by 24 to get my total days?

Thanks,
Linda