View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ManualMan ManualMan is offline
external usenet poster
 
Posts: 35
Default Problems making a formulas in excel

Hi,

If you put a time in an excel window, like 08:30:14, it is instantly
converted to Excels datetime, which is the number of days from 1st of
January 1900 or so.

To add 6 hours, just add .25 (6 divided by 24) to the time, and format
the cell in date time format.
Regards,
ManualMan
http://www.gamesXL.tk