Thread: How do I add numbers to time?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Dave is offline
external usenet poster
  
Posts: 1,388
Default How do I add numbers to time?
Hi,
When you add numbers to time, XL treats those numbers as days, so you need
to divide by 24 if you want hours.

If 7:30 AM is in A1...
=A1+(4.25/24)
Format like A1

Regards - Dave.
Reply With QuoteReply With Quote