Time is expressed as a fraction of a full day for the purpose of calculation. Here are typical formulae to obtain decimal equivalents of time cell X00:
=X00/7 to get weeks
=X00*24.0 to get hours
=X00*24.0*60.0 to get minutes
=X00*24.0*60.0*60.0 to get seconds
etc.
