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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subtracting time...again 2
date and time difference 19
Finding Date in an overseas format 21
Computing Elapsed Time 4
Check if time falls between two times? 5
separating date and time 5
Timetable 7
Left Function Question Help! 3

Top