Time is confusing in Excel.....

  Simsy 12:43 30 Aug 2003

Format the cell you want the new figure to appear in as "number", (probably with 2 dec places),

Then multiply the value of the cell by 24....

eg if time in cell A1 is 06:45 put the following formula in cell B1;


this will give the value in B1 as 6.75

Is thatwhat you want?



This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Honor View 20 review

How Esports branding got a brand new look

Best free Mac apps

Les meilleurs VPN gratuits (2019)