Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Calcuations with time data

  • kateporcheret
  • kateporcheret's Avatar Topic Author
  • Offline
  • New Member
  • New Member
More
10 years 4 months ago #100958 by kateporcheret
Calcuations with time data was created by kateporcheret
Hello,

I am creating a survey to look at sleep and need to know bed times and get up times. I would like to be able to provide people with feedback about their sleep such as sleep duration. To do this I need to do some simple calculations with the times they provide. I have made questions with hour and minute drop down boxes, but can't figure out how to do the calculations. In excel I would use: wake time +(24-bed time). Is there a way to do this is LimeSurvey?

Thanks
The topic has been locked.
More
10 years 4 months ago #100962 by mfaber
Replied by mfaber on topic Calcuations with time data
You may be able to do this using the function strtotime(). It's fairly new in LS and seems to work well with dates. I have not tested it myself to work with times but in principle it should work. Have a look here:
manual.limesurvey.org/Expression_Manager...ce_between_two_dates
and here:
www.php.net/manual/en/function.strtotime.php

Please be aware that strtotime() works with a lot of different but not ALL date formats. Limesurvey's default date format (MM-DD-YYYY) does NOT work with strtotime(). Please set your survey to use one of the following date formats to avoid problems: YYYY-MM-DD, YYYY/MM/DD, DD.MM.YYYY, MM/DD/YYYY, DD-MM-YYYY.
For times, you are probably on the safe side using HH:MM
The following user(s) said Thank You: kateporcheret
The topic has been locked.
More
10 years 4 months ago #100963 by Ben_V
Replied by Ben_V on topic Calcuations with time data
hi,
if you want to go further with time calculation it may be better to retrieve times using just one (numerical) question.
Have a look here to get another approach using a 'timepicker' question

Benoît

EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
The following user(s) said Thank You: kateporcheret
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose