Calculate Date and time

D

Douglas

I would like to know how to calclate date and time "01-02-2004 16:00" to "02-02-2004 15:20". Iwould like to get the answer in hours.
 
F

Frank Kabel

Hi
if both values are in A1 and B1 enter the following formula
=B1-A1
and format this cell with the custom format
[hh]:mm
-----Original Message-----
I would like to know how to calclate date and time "01-02-
Click to expand...
2004 16:00" to "02-02-2004 15:20". Iwould like to get the
answer in hours.
 

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
How to get largest date from a Vlookup 1
Sum amounts based on date field 6
count not-overlapping days in a "Table" with Beginning and EndingsDates Specified 0
Sort by placement value from left to right & adding trailing zeros for short 3
If Function 1
Copy value according to date 1
Modifying a complex date formual to count months 4

Top