Show timesheet time in and out in regular time versus military tim

G

Guest

I have a timesheet as follows: Col C is labeled ‘In’ for start time in
military time, Col D is labeled ‘Out’ for stop time in military time, Col E
is total hours worked with formula beginning in row 10, where data input
begins, as =D10-C10+(D10<C10). Also on row 10. in Col F is labeled ‘In’ for
start time in military time, Col G is labeled ‘Out’ for stop time in military
time, Col H is total hours worked with formula =G10-F10+(G10<F10). Col I has
the total of columns E and H with the formula =E10+H10. Data in rows C, D, E,
F, G, H is formatted Custom h:mm and data in Col I is formatted [h]:mm. I
would like to have the times in Columns C through H to read as regular time
(such as 2:25PM as opposed to 14:25).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating time without using military time 4
Conditional Multiply and Sum 2
Allocation 4
entering time in and time out 1
Totaling columns 4
Annual Wages Sheet to pick up info from Time Sheet 2
Selcting data from table without repeating plus calc's 2
Find a number in a column then return a value from another cell 2

Top