Hi guys,
I have a data frame imported from Excel via csv. I have two sets of time periods, bed time and wake time, and I want to create a new column that calculates the elapsed time between these two times, e.g. for the first example, the answer is 8 hours. Do you know how I can do this?
> head(females)
gender dob student.height height.dad height.mum bed.time wake.time
1 female 1985 164.00 172.00 155.00 22.30.00 06.30.00
2 female 1990 167.64 177.80 157.48 21.30.00 06.15.00
3 female 1990 165.00 178.00 165.00 22.00.00 07.00.00
4 female 1991 171.00 188.00 169.00 22.00.00 06.45.00
5 female 1991 177.80 182.88 167.64 22.00.00 07.00.00
6 female 1992 162.56 170.18 162.56 21.30.00 07.00.00```
Thanks!