Hi

Excel stores times as fractions of a day (24 hours) so use
=(C1-B1)*24

--

Regards
Roger Govier

"gkarasiewicz" wrote in message
...
Okay here is my issue.

I have the 1600-2400 in A1

now in B1 I want 1600(Start Time) to be a time value

And in C1 i want 2400(End Time) to be a time value

Then in D1 i want to find out the total hours, in this case 8