Difference in time

P

pcor

What do I have to do to find out how many hours and minutes between the 2
following date/times
25 Feb 2006 0908 AM
27 Feb 2006 0200 PM
I have tried some formatting but never got the right answer
Thanks in advance
PCOR
 
S

Sandy Mann

You don't say what formtting you have tried but assuming that the date &
time is in the same cell, I got 52:52 by formatting the subtraction cell as
[h]:mm


--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk
 
P

pcor

Thanks again..I did finally get it going


Sandy Mann said:
You don't say what formtting you have tried but assuming that the date &
time is in the same cell, I got 52:52 by formatting the subtraction cell as
[h]:mm


--
HTH

Sandy
(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

pcor said:
What do I have to do to find out how many hours and minutes between the 2
following date/times
25 Feb 2006 0908 AM
27 Feb 2006 0200 PM
I have tried some formatting but never got the right answer
Thanks in advance
PCOR
Click to expand...
Click to expand...
 

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

How can count the number of cells that fulfill certain criteria in other cells 2
date and time in 2 cells to create subtraction in 3rd 2
Word VBA - Want to test if Full Name is NOT Present in document 0
Computing Elapsed Time 4
Subtracting time...again 2
Recurring tasks occur during non-working times 0
Rearranging rows & Cloumn( Please help me) 2
Date Format - simple question 1

Top