Thread: CONVERT TIME FROM 4:30 TO 4.5
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default CONVERT TIME FROM 4:30 TO 4.5
If A1 contains 4:30:00 (AM), then
=a1*24
(Format as general, not a time!)

And you'll see 4.5



keeb wrote:

I'm tring to convert a time ie. 4:30 to a interger ie. 4.5. can anyone help?

--

Dave Peterson
Reply With QuoteReply With Quote