Thread: Time
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karen Karen is offline
external usenet poster
 
Posts: 447
Default Time

Hello, I have been reading the posts on converting time to a decimal. It
worked for 36:24:03, but I can't get it to work for 2:14:03. I get a "value"
error. Can you help me with this please

"Teethless mama" wrote:

=A1*24

Format cell as General


"snikta" wrote:

I am creating a time sheet. I need to convert a time format (7:30) to a
decimal format (7.50). How do I do this?