P
Peter Gonzalez
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
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