Time calcualtion in minutes
Judy,
Format the cell as custom with the format
[mm]:ss
HTH,
Bernie
MS Excel MVP
"Judy Gleeson" wrote in message
...
Excel 2007
Working with an .xls template used as a timesheet. Three columns time
started, time finished and time taken.
Can Time Taken be shown as minutes? We can subtract end from start time
and
get to see it as hh:mm but can't get just mm as the correct total number
of
minutes. eg if 9:30 to 11:00 is 1 1/5 hours, can we see a total as 90
minutes
somehow?
JudyG
|