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
[TABLE="width: 257"]
<TBODY>[TR]
[TD="class: xl67, width: 158, bgcolor: transparent"]Employee #
[/TD]
[TD="class: xl80, width: 92, bgcolor: transparent, colspan: 2"]Friday
[/TD]
[TD="class: xl80, width: 92, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl68, bgcolor: transparent"]Employee Name
[/TD]
[TD="class: xl78, bgcolor: transparent, colspan: 2"]11/15
[/TD]
[TD="class: xl78, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl73, bgcolor: transparent"][/TD]
[TD="class: xl70, bgcolor: transparent"]IN:
[/TD]
[TD="class: xl84, bgcolor: transparent"]14:00
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl82, bgcolor: transparent"][/TD]
[TD="class: xl71, bgcolor: transparent"]OUT:
[/TD]
[TD="class: xl84, bgcolor: transparent"]22:00
[/TD]
[TD="class: xl66, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="class: xl72, bgcolor: transparent"][/TD]
[TD="class: xl76, bgcolor: transparent"]HRS:
[/TD]
[TD="class: xl72, bgcolor: transparent"]8
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[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!!