G Guest Aug 22, 2004 #1 I want to put 9:00 am in a cell and then 12:15 pm in the next cell and have it generate the answer 3.25 hours in the next cell.
I want to put 9:00 am in a cell and then 12:15 pm in the next cell and have it generate the answer 3.25 hours in the next cell.
S Sandy Mann Aug 22, 2004 #3 With 9:00 in A1, 12:15 in B1 try =(B1-A1)*24 formatted as General HTH Sandy