Calculating Time

[Tony]

This may have been asked many times before, but here it
goes:

1) How do you enter a formula to calculate time
difference in C1 and NOT expressed in minutes (ie. 7.50
instead of 07:30:00) ?
2) How do I sum C1:C3 and NOT express in minutus (ie.
15.50 instead of 15:30:00)?
A B C
Start Finish Total Hours Worked less 1/2 hour
1 7:00 am 3:00 pm
2 7:00 am 3:30 pm

Thanks in advance.

 

[Chip Pearson]

Multiply the time difference by 24. E.g.,

=(B1-A1)*24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com