View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Judy Gleeson Judy Gleeson is offline
external usenet poster
 
Posts: 1
Default Time calcualtion in minutes

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