Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM
 

Im trying to figure out the range of time spent from two different days. Say
I have on 1/21/2010 4:00 AM in Cell C14 and 1/22/2010 10:00 AM in Cell G14.
I've tried doing (G14-C14) but all i get is 6:00 becasue i need to have it
formatted as (Hr:Min). How would I get it to just have the total amount of
hours from the time elapsed in that span that I'm working with?

Thanks

Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM
 

Use custom format [h]:00
The square backers [] allow hours to exceed 24
If you want, fro example, 4:30 to display as 04:30 use two h's as in [hh]:mm

best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Peter Gonzalez" wrote in message
...
Im trying to figure out the range of time spent from two different days.
Say
I have on 1/21/2010 4:00 AM in Cell C14 and 1/22/2010 10:00 AM in Cell
G14.
I've tried doing (G14-C14) but all i get is 6:00 becasue i need to have it
formatted as (Hr:Min). How would I get it to just have the total amount of
hours from the time elapsed in that span that I'm working with?

Thanks

Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM
 

Use a custom format of:

[h]:mm

which will display hours without wrapping them at 24, i.e. 30:00.

Hope this helps.

Pete

On Jan 26, 6:45*pm, Peter Gonzalez
wrote:
Im trying to figure out the range of time spent from two different days. Say
I have on 1/21/2010 4:00 AM in Cell C14 and 1/22/2010 10:00 AM in Cell G14.
I've tried doing (G14-C14) but all i get is 6:00 becasue i need to have it
formatted as (Hr:Min). How would I get it to just have the total amount of
hours from the time elapsed in that span that I'm working with?

Thanks