-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
hour format
-
D
Convert to minute elapsed from specific field
Hello, i got a list of tickets with the dedicated time for each, i want to convert it in excel so i can sum the time consumed per week, but the time comsumption needs to be converted i wanted to make with if functions but maybe there is a more easier way, i identified 3 variants: -1h -1h 30m...- darzu
- Thread
- hour format minute time
- Replies: 3
- Forum: Excel Questions
-
J
Timesheet - Hour +/-
Hi i have this table for a timesheet with the following formula: <tbody> H I J K Day In Out Formula OT 25% OT 25% Formula OT 50% OT 50% 1 8 17 =SI(I3>=19.1,"3",(I3-H3-9)) 0 =(I3-H3-9-J3) 0 2 8 19 =SI(I3>=19.1,"3",(I3-H3-9)) 2 =(I3-H3-9-J3) 0 3 8 21 =SI(I3>=19.1,"3",(I3-H3-9)) 2...- JAGTOO
- Thread
- 25% 50% hour format timesheet total
- Replies: 1
- Forum: Excel Questions
-
J
Extract hours from a string text.
Hello. I'm trying to add the hours in a schedule created in an excel spreadsheet. The information is formatted as "8am to 5pm" in each cell (varies of course depending in the individuals schedule). What I would like to do is translate anything with a "pm" into a 2400 format and then subtract...- jrschenck
- Thread
- hour format pulling numbers from text two number in one cell
- Replies: 5
- Forum: Excel Questions
