How do I get the varience/hours between say 10:00 AM to 3:00 PM = 5 hrs.?
I itsagoodlife Jan 13, 2007 #1 How do I get the varience/hours between say 10:00 AM to 3:00 PM = 5 hrs.?
D David Biddulph Jan 13, 2007 #2 10:00 AM in A1 3:00 PM in A2 =A2-A1, formatted as [h]:mm would show 5:00 If you want 5 as a number for further processing, then use =(A2-A1)*24 and format as number or general.
10:00 AM in A1 3:00 PM in A2 =A2-A1, formatted as [h]:mm would show 5:00 If you want 5 as a number for further processing, then use =(A2-A1)*24 and format as number or general.
