Hi,

=B1-A1
format as [hh]:mm

earlier date and time In A1

Mike

"Nick" wrote:

I am needing to calculate how long an item was used for using hours and
minutes.
Is there a formula or format that will let me do this.
The total will go into thousands of hours.
And i cannot have days or seconds, must only be hours and minutes in my
spreadsheet.

Can anyone help