Time Question

F

Frank Kabel

Hi
try
=MOD(A1,1)-TIME(7,0,0)

or
=MOD(A1,1)-7/24

format the resulting cell as time
-----Original Message-----
What formula and formatting would I use to determine the
Click to expand...
time period between a dtae/time (dd/mm/yy hh:mm) and a
fixed time say 7AM
 
Top