S Sandy Mann Sep 2, 2007 #2 Custom Format the cell as [h]:mm the square brackets will stop the hours rollong over into days when they get to 24 hours. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
Custom Format the cell as [h]:mm the square brackets will stop the hours rollong over into days when they get to 24 hours. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk
D David Biddulph Sep 2, 2007 #3 But that's not in decimal.. To convert from Excel time format to decimal hours, multiply by 24 and format as number or general. -- David Biddulph Sandy Mann said: Custom Format the cell as [h]:mm the square brackets will stop the hours rollong over into days when they get to 24 hours. Click to expand...
But that's not in decimal.. To convert from Excel time format to decimal hours, multiply by 24 and format as number or general. -- David Biddulph Sandy Mann said: Custom Format the cell as [h]:mm the square brackets will stop the hours rollong over into days when they get to 24 hours. Click to expand...
S Sandy Mann Sep 2, 2007 #4 Oh yes! I forgot about that bit <g> Time for bed I think. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk David Biddulph said: But that's not in decimal.. To convert from Excel time format to decimal hours, multiply by 24 and format as number or general. -- David Biddulph Sandy Mann said: Custom Format the cell as [h]:mm the square brackets will stop the hours rollong over into days when they get to 24 hours. Click to expand... Click to expand...
Oh yes! I forgot about that bit <g> Time for bed I think. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings (e-mail address removed) Replace @mailinator.com with @tiscali.co.uk David Biddulph said: But that's not in decimal.. To convert from Excel time format to decimal hours, multiply by 24 and format as number or general. -- David Biddulph Sandy Mann said: Custom Format the cell as [h]:mm the square brackets will stop the hours rollong over into days when they get to 24 hours. Click to expand... Click to expand...