View Single Post
 
Old 11-14-2016, 08:10 PM
jiaron_1230 jiaron_1230 is offline Windows 10 Office 2016
Novice
 
Join Date: Nov 2016
Posts: 2
jiaron_1230 is on a distinguished road
Default How to set the table cells as time format?

in the column "from" and "to", is let the user to key in their working time, format as 24hr
after that, in std, n/std, n/std2, each of it hv different time area

std= 0800 - 1700
n/std=1701-2400
n/std2=2401-0759

i would like to do is calculate the hours that user had work.
Example,
from to std n/std n/std2
0900 0200 8 7 2

Can anyone help me with this?
Attached Files
File Type: docm test.docm (40.8 KB, 12 views)
Reply With Quote