Payroll and Time without a colon

[mdsmith000]

So I have timesheet that is working pretty awesome however for data entry I want to be able to not have to use the Colon ) when entering time. I figured how to do that, but it does not add my time up correctly when I changed it.


I currently use =MOD(C6-C5,1)*24 to add the hours up, and my two cells are formated at "Time" 13:30

Thanks

Employee #	Friday
Employee Name	11/15
	IN:	14:00
	OUT:	22:00
	HRS:	8

<TBODY>
</TBODY>

 

[SlinkRN]

Try this in place of you original MOD formula: =MOD(TEXT(C6,"00\:00")+0-TEXT(C5,"00\:00")+0,1)*24
What it does is put the 1400 and 2200 back into the time format before doing the calculation. HTH, Slink

 

[mdsmith000]

Awesome thank you!!