G
grilla79
I am using a spreadsheet with military time expressed as hhmm (no ":").
I need to be able to add time intervals, expressed in minutes (not i
decimals of hours) to these military times to get estimated timef o
completion in the same time format (HHMM). For example, at 1835 w
started a project estimated to take 145 minutes complete. I can do th
math in my head to see that 145 minutes = 2 hours and 25 minutes for a
ETA of 2050 but I can't make the spreadsheet do it. I'd appreciate an
help
Thanks
Do
I need to be able to add time intervals, expressed in minutes (not i
decimals of hours) to these military times to get estimated timef o
completion in the same time format (HHMM). For example, at 1835 w
started a project estimated to take 145 minutes complete. I can do th
math in my head to see that 145 minutes = 2 hours and 25 minutes for a
ETA of 2050 but I can't make the spreadsheet do it. I'd appreciate an
help
Thanks
Do