Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

formula help with symbols added

Irene Plant
edited 12/09/19 in Archived 2015 Posts

I have used a google form for time worked and synced it with smartsheet. I then have a column on my sheet to work out how many hours have been worked on a particular day using the information supplied on the entry from the google form. For instance if Joe worked 09:00 to 17:00 and entered this on his google form submission I want my sheet to be able to work out how many hours Joe worked (17:00 - 09:00). Does anyone know the formula to use in my 'hours worked' column, I have applied the usual formula of =([start time]1)-([finish time]1) but it doesn't work I think because it doesn't recognise the symbol ( : ) part of the time they have entered.

Many thanks,


This discussion has been closed.