Thread: Change time h:mm to a decimal number based on hours
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
DazzaData DazzaData is offline
external usenet poster
  
Posts: 49
Default Change time h:mm to a decimal number based on hours
Hi,

Just multiply it by 24 and format as a regular number

Cheers

"Snort5525" wrote:

We have a spreadsheet with columns for time started and time finished. The
data shows up as hh:mm. A third column is the difference between these first
two, showing total hours and minutes spent on the task. How can I show the
data in the third column as hours to two decimal places?
Reply With QuoteReply With Quote