Totaling Time (Timesheet)

[Ken Schumacher]

Can I use Excel as a so called "timesheet"?

Let's say I have column B set-up for entering start times,
and column C set-up for entering finish times.
Can I have column D figure out how many minutes or hours were spent?

ie:
B4=10:00AM
C4=11:30AM
Therefore:
D4=1.50

Thanks,
-Ken

 

[Peo Sjoblom]

D4 is

=(C4-B4)*24

 

[Maurice]

Try the attached, its based on a 36 hour week or 7:12 a da

+----------------------------------------------------------------
| Attachment filename: lauraofficetime.zip
|Download attachment: http://www.excelforum.com/attachment.php?postid=356789
+----------------------------------------------------------------