|
|
how can we calculate the numbers of hours between two dates and
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.
|
|
0
|
|
|
|
Reply
|
 Utf
|
4/13/2010 5:40:01 PM |
|
=B1-A1, format Custom as [h]:mm
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Rama Chandra" <Rama Chandra@discussions.microsoft.com> wrote in message
news:1AE69E13-2B22-4CBA-9E0B-3B2665C466E1@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.
>
|
|
|
0
|
|
|
|
Reply
|
Niek
|
4/13/2010 6:07:29 PM
|
|
=(+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.
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/13/2010 6:22:05 PM
|
|
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.
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/13/2010 6:25:01 PM
|
|
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.
>
|
|
|
0
|
|
|
|
Reply
|
Utf
|
4/13/2010 6:29:01 PM
|
|
|
4 Replies
462 Views
(page loaded in 0.22 seconds)
Similiar Articles: how can we calculate the numbers of hours between two dates and ...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. ... How To Calculate the Number of Fridays between two dates ...how can we calculate the numbers of hours between two dates and ... How To Calculate the Number of Fridays between two dates ... Can any body tell me how to calculate the ... How to do a formula counting the number of hours between 2 times ...how can we calculate the numbers of hours between two dates and ..... exact number of hours between two different dates and times ... dates how to count only ... number ... Formula for calculating time period between 2 dates - microsoft ...how can we calculate the numbers of hours between two dates and ... Formula for calculating time period between 2 dates - microsoft ... This working time can be... Calculating diff btwn two dates how to count only business days ...how can we calculate the numbers of hours between two dates and ... Calculating diff btwn two dates how to count only business days ... Calculate difference between hours ... How to use custom format [h]:mm like in excel - microsoft.public ...how can we calculate the numbers of hours between two dates and ... =B1-A1, format Custom as [h]:mm -- Kind regards, Niek Otten Microsoft MVP - Excel ... one and then use ... Counting Days between two Dates excluding weekends - microsoft ...how can we calculate the numbers of hours between two dates and ... Calculating diff btwn two dates how to count only ... number of days between two ... Summary of Difference between dates in years, months, days ...how can we calculate the numbers of hours between two dates and ... Calculate duration between two dates - timeanddate.com The duration calculator calculates the ... How to Calculate Business Days and Hours? - microsoft.public ...how can we calculate the numbers of hours between two dates and ... Calculating diff btwn two dates how to count only business days ... how can we calculate the numbers of ... Calculate hours - times go into next day - microsoft.public.excel ...how can we calculate the numbers of hours between two dates and ... Calculate hours - times go into next day - microsoft.public.excel ..... to calculate number of hours ... Calculate duration between two dates with time - timeanddate.comCalculate duration between two dates with time. This service calculates the duration, counting the number of years, months, days, hours, minutes and seconds between ... Calculate duration between two dates - timeanddate.comThe duration calculator calculates the difference in number of days, months and years between two dates. how can we calculate the numbers of hours between two dates and ...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. ... How to Calculate Work Days Between Two Dates | eHow.com... need to calculate the number of work days between two dates. ... How to Calculate Hours in Excel Excluding Weekends; How to Calculate the Days Between Two Dates on ... 2009, we ... Getting the difference between dates - Ask Tom HomeFrequently we are asked -- how can I find the number of minutes between two dates or what is the ... can get either TOTAL (days, hours, minutes, seconds) between 2 dates ... 7/16/2012 7:54:41 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
66 followers. 