View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Snort5525 Snort5525 is offline
external usenet poster
 
Posts: 4
Default Change time h:mm to a decimal number based on hours

Thank you for your assistance.
Your quick answer was right on point.

"DazzaData" wrote:

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?