Ok.. Is trying to sort out how to make the following.
I need a timesheet to record hours and minutes that a person has worked in a day.
I can make a basic one which calculates hours. but want to have one that successfully calculates minutes.
instance if a person starts at 8:12 am and finishes at 12:14pm
then restarts at 1:13pm and finishes at 5:13pm.
the work i am at uses time cards witha military time format.
however people will also write in normal time as well .
Is it possible to figure out a combination of cell format
and formula to make this work..
have a sheet that I adapted from something i found on the web but if i change
calculations it doesnt seem to work right.
it gives calculations to 100 minutes.
Tried to use a basic
[h]:mm format but that didnt work.
Im not sure if i have the cell formats correct or the formulas correct.
adapted a formula and cell format I found.
but would much rather try and learn how to do it so i understand.
on the time input cells it is formatted as
Basically I want to be able to enter EITHER military time (on the stamped timesheets) or standard time indicating either AM
or PM so I guess it is H:mm AM/PM format..
the calculated fields is formatted as
_(* #,##0.00_);_(* (#,##0.0);;_(@_)