apache poi excel hours format set cell value java -


i working on excel generation , did functionality in excel, 1 problem occurs. want set cell value hh:mm not date. have string 12:45,36:30,102:50. each cell but, want detect cells time format greater 24 hours in excel , if select cells, show sum of hours on excel. don't know how that. found similar post on stack ( hh:mm:ss xls reading using apache poi), post shows how read cells. want set cell value greater 24 hours format hours , minutes 25:00, 205:00, 152:30.

can me? appreciate effect!

promoting comment answer....

excel stores dates integer days since 1900 or 1904, depending on setting, ish... (there's leap year issues in there). excel stores times fractions of day. so, on 1900 window'd file, depending on format string used

0.1 = 02:24:00 0.5 = 12:00:00 1.5 = 1900-01-02 12:00:00 1.5 = 36:00:00

so, if want store , display 36 hours, work out fraction of day (1.5), apply formatting string supports >36 hours. format hh:mm , you'll 12:00. format [hh]:mm , you'll 36:00

use excel work out format string need - poi writes format string give file, , excel renders if you'd written in excel!


Comments

Post a Comment

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

Image
i have page in each contest shown in row. each row contains contest id , link other model names have foreign key contest. news model: class news(models.model): title = models.charfield(max_length=50, null=true) description = models.textfield() time = models.timefield( default= datetime.datetime.now().time()) contest = models.foreignkey(contest) i want use admin adding , changing these models. want when user clicks on 'news' has foreign key contest id=1, shows list of news value foreign key. use {% instance in instances %} <tr class="{% cycle 'row1' 'row2' %}"> <td>{{ instance.title }}</td> <td>{{ instance.starttime }}</td> <td>{{ instance.timespan }}</td> <td>{{ instance.date }}</td> <td><a href="/adm...
Read more

android - Keyboard hides my half of edit-text and button below it even in scroll view -

i having trouble keyboard covers edit-text , half of button in scroll view. here's layout , please tell me how should resolve problem. many questions on topic none of them s working me. <?xml version="1.0" encoding="utf-8"?> <linearlayout xmlns:android="http://schemas.android.com/apk/res/android" android:layout_width="match_parent" android:background="@drawable/bg" android:layout_height="match_parent"> <scrollview android:layout_width="match_parent" android:fillviewport="true" android:layout_height="match_parent"> <relativelayout android:layout_width="match_parent" android:layout_height="wrap_content" android:orientation="vertical"> <linearlayout android:layout_width="match_parent" android:layout_height="w...
Read more

css - Make div keyboard-scrollable in jQuery Mobile? -

from can tell, although jquery-mobile-powered pages can contain divs overflow set scroll or auto, , these divs can scrolled one-screen bar or mouse wheel, cannot scrolled using arrow keys, page-up/page-down, or home/end. instead, official "page" div (with data-role="page") absorbs input. perhaps other divs can't acquire focus, i'm not sure. is there way around this? edit: jsfiddle of simple example: https://jsfiddle.net/qogz0shx/ <script src="https://ajax.googleapis.com/ajax/libs/jquery/2.1.4/jquery.min.js"></script> <script src="https://ajax.googleapis.com/ajax/libs/jquerymobile/1.4.5/jquery.mobile.min.js"> </script> <link rel="stylesheet" href="https://code.jquery.com/mobile/1.4.5/jquery.mobile-1.4.5.css"/> <style> #outer { overflow:scroll; height: 50vh; width: 50vw; } #inner { height: 500vh; width: 500vw; } ...
Read more