Prev: How do I strike through a row of datas?
Next: Moving Hyperlinks
From: Rama Chandra Rama on 13 Apr 2010 13:40
i need to calculate the exact number of hours between two different dates and
times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18.

From: Niek Otten on 13 Apr 2010 14:07
=B1-A1, format Custom as [h]:mm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rama Chandra" <Rama Chandra(a)discussions.microsoft.com> wrote in message
news:1AE69E13-2B22-4CBA-9E0B-3B2665C466E1(a)microsoft.com...
>i need to calculate the exact number of hours between two different dates
>and
> times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18.
>

From: Gary Brown on 13 Apr 2010 14:22
=(+A2-A1)*24
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Rama Chandra" wrote:

> i need to calculate the exact number of hours between two different dates and
> times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18.
>
From: JLatham on 13 Apr 2010 14:25
Subtract the earlier value from the later one and then use Format --> Custom
format:
[h]:mm:ss
For example with 04/12/10 10:23 AM in A1 and 04/15/10 15:18 in B1 then
=B1-A1
and with the custom formatting applied will display 76:55:00, which is 76
hours and 55 minutes.


"Rama Chandra" wrote:

> i need to calculate the exact number of hours between two different dates and
> times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18.
>
From: JLatham on 13 Apr 2010 14:29
If you would rather have the result as a decimal number (76.91667 hours for
the previous example), then
=(B1-A1)*24
and format the cell as either General or one of the Number formats.

"Rama Chandra" wrote:

> i need to calculate the exact number of hours between two different dates and
> times, e.x. 04/12/10 10:23 AM and 04/15/10 15:18.
>
 | 
Pages: 1
Prev: How do I strike through a row of datas?
Next: Moving Hyperlinks