Joshua,

Simply subtract the earlier from the later tiem

=B1-A1

and then format that cell with

[h]:mm

Mike



"Joshua" wrote:

I am trying to get the difference between date and time into the hh:mm format.
Example:

Start Date End Date Time taken to complete
7-1-09 8:00 AM 7-2-09 8:30 AM 24:30

How can i get it to calculate the difference between the date and the time