Spreadsheets store and manipulate date/time/calendar information in the form of double precision serial numbers. The integer portion of the numbers represents days/date, and the fractional portion represents fraction of a day or time of day. When you have days.fraction information, the MOD(day.fraction,1) function is a convenient way of extracting just the fraction/time of day information.