Convert Time to Numbers in Excel

  [DELETED] 12:28 30 Aug 2003

Can anyone help please - Is there a formula to convert time to whole numbers? For example - how would you convert 06:30 (Formatted as Time) to read 6.50 (Formatted as Figures).

  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?



  [DELETED] 12:44 30 Aug 2003

Format the cells to time format.

Put the time in, change to number format and multiply by 24

Time is stored as fraction of day, so 12PM is .5 Times that by 12 and you get 12

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

Elsewhere on IDG sites

Microsoft Surface Book 2 15in review

How to create explosive dance music graphics

When is the best time to buy an iPhone?

Quel antivirus gratuit choisir pour un PC ?