Time

• =hour(), =minute(), =second()
  • You will probably have to format these.
• =time(hour, min,sec) will covert integers to time.
• Extracting time from a datetime feld
  • =A1-int(A1)
  • =time(hour(a1),minute(a1), second(a1))