simple calculating timesheet

[SSFAN]

How to make the billable time calculate in column E when entering start time in column C and ending time in column D? See image.

I want to do the time entries in column C and D using keyboard shortcuts if possible.
Designating AM and PM will matter when calculating the time difference between column D and column C.
When I enter time entries using ctrl+shift+; they appear correctly, but column E displays #VALUE!
I've also tried manual entry [2:45 PM etc.] with the same result.

I have tried D2-C2 [etc.] and =SUM(D2-C2) [etc.]
I've also tried changing the time format [format/cells/number/time].
I am using Excel 2000.
I'd like column E to add the billable hours entries and create a total thus: 12:45 [12 hours and 45 minutes]

All help greatly appreciated.

Gary

 

[alansidman]

Book4
	A	B	C	D	E
1	Date	Services	Start Time	End Time	Billable
2	8/7/2024	prepare	1:36 PM	1:37 PM	0:01
3	8/7/2024	prepare	2:30 PM	2:45 PM	0:15
Sheet1

Cell Formulas
Range	Formula
E2:E3	E2	=D2-C2

and format the last column in custom formatting as h:mm

Not sure why it is not working for you. Cannot discern from a picture. If you wish further analysis, post your workbook to either box.net or dropbox.com and post a link here.

 

[SSFAN]

Thanks.