Hours between dates

[Linda RQ]

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

 

[FSt1]

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

 

[Bob Phillips]

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

 

[Rick Rothstein]

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

=24*(H2-G2)

 

[Linda RQ]

You Da Man Rick! Thanks!

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

=24*(H2-G2)

 

[Linda RQ]

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!

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

--
__________________________________
HTH

Bob

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

 

[Linda RQ]

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


Linda

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

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

 

[FSt1]

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

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


Linda

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

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

 

[Bob Phillips]

It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

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!

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

--
__________________________________
HTH

Bob

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

 

[Linda RQ]

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

It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

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!

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

--
__________________________________
HTH

Bob

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

 

[Rick Rothstein]

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

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

--
Rick (MVP - Excel)

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

It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

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!


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

--
__________________________________
HTH

Bob

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

 

[Bob Phillips]

No it would be

=B1-A1

as the formula in the cell, then select menu Format>Cells>Custom and enter
[h]:mm in the inputbox.

--
__________________________________
HTH

Bob

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

It is square brackets, not parentheses.

--
__________________________________
HTH

Bob

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!


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

--
__________________________________
HTH

Bob

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