Number of hours between now and selected date

[Igor]

I need a formula to calculate number of hours between data and time set in
the cell by function NOW() and a set date in the same format:

Example:

NOW() - return 29/07/2009 16:06:00
set date - 07/08/2009 06:00:00
result to be difference between the dates presented in hours

 

[Mike H]

Hi,

with the eralier date/time in A1 and the later in b1 try

=B1-A1

Format the cell as [hh]:mm

Mike

 

[Igor]

Thank you I tried, it returns only hours and minutes, however, days are
missed in the return

Hi,

with the eralier date/time in A1 and the later in b1 try

=B1-A1

Format the cell as [hh]:mm

Mike

I need a formula to calculate number of hours between data and time set in
the cell by function NOW() and a set date in the same format:

Example:

NOW() - return 29/07/2009 16:06:00
set date - 07/08/2009 06:00:00
result to be difference between the dates presented in hours

 

[Mike H]

Hi,

If the days will never exceed 31 then you can get away with changing the
format to

dd:hh:mm

if it will/may exced 31 then use

=INT(B1-A1) & " " &TEXT(B1-A1,"hh:mm:ss")

Mike

Thank you I tried, it returns only hours and minutes, however, days are
missed in the return

Hi,

with the eralier date/time in A1 and the later in b1 try

=B1-A1

Format the cell as [hh]:mm

Mike

I need a formula to calculate number of hours between data and time set in
the cell by function NOW() and a set date in the same format:

Example:

NOW() - return 29/07/2009 16:06:00
set date - 07/08/2009 06:00:00
result to be difference between the dates presented in hours

 

[David Biddulph]

If you want to show a number of hours beyond 24, [hh]:mm will show them.
Formatting as hh:mm (without the square brackets) would not.

If you want to return the number of hours as a decimal, then use
=(B1-A1)*24, and format as general or number, not as time.
--
David Biddulph

Thank you I tried, it returns only hours and minutes, however, days are
missed in the return

Hi,

with the eralier date/time in A1 and the later in b1 try

=B1-A1

Format the cell as [hh]:mm

Mike

I need a formula to calculate number of hours between data and time set
in
the cell by function NOW() and a set date in the same format:

Example:

NOW() - return 29/07/2009 16:06:00
set date - 07/08/2009 06:00:00
result to be difference between the dates presented in hours

 

[Fred Smith]

That's because you asked for the number of hours (see your subject). If you
wanted to know the number of days, you need to specify that. Responders here
will answer the question that's asked.

Regards,
Fred

Thank you I tried, it returns only hours and minutes, however, days are
missed in the return

Hi,

with the eralier date/time in A1 and the later in b1 try

=B1-A1

Format the cell as [hh]:mm

Mike

I need a formula to calculate number of hours between data and time set
in
the cell by function NOW() and a set date in the same format:

Example:

NOW() - return 29/07/2009 16:06:00
set date - 07/08/2009 06:00:00
result to be difference between the dates presented in hours