datetime calculation HELP !!!!

[steve]

I get data that is mm/dd/yy hh:mm:ss. I need to figure the
hours between two dates and times (like a begin date and
end date)to see how many hours were spent performing a
task.

 

[Peo Sjoblom]

=A1-A2 where A1 holds end and A2 start, custom format
[h]:mm to make hours roll over 24

 

[Rick C]

=B1-A1
formatted as [h]:mm

 

[StarTrek an beyond]

to get the hours & the sum of in a column =HOUR((SUM(F118:F122)))
to get the hours & the sum of in a column =MINUTE((SUM(F118:F122)))
puttting it together for totals minutes
=MINUTE(SUM(F118:F122))+(HOUR((SUM(F118:F122)))*60)

This will give the totals hours & minutes in decimal for =(I118*(1/60)) that
you can use to find the amount in dollars
NOTE: replace the column/row numbers with yours.

Wayne B